Hi,
I thought I had found the solution but is doesn't work:

I have a number of Cells which I have named and wish to check if th
value = a result in another cell:

for example:

A1 contains the string "NED"
In another sheet I have the country's name: Countries!A1 = "Nederland
and the cellname, reference is NED

so if I type in any other cell X1=NED the result = "Nederland"

Now I have a soccerpool and a test the result is WINNERA

In this cell is NED is the winner the value NED is selected

What I need to know is how can I compa

IF WINNERA = NED Then ...... Else .....

Thanks, as you may understand it's for the Soccer World Championship i
Juni 2006

Hans:confused

--
hhall

Mal
-----------------------------------------------------------------------
hhalle's Profile: http://www.excelforum.com/member.php...fo&userid=2082
View this thread: http://www.excelforum.com/showthread.php?threadid=49784