I may be missing the question here, but you should be able to do

=IF(WINNERA=NED,"y","n")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"hhalle" wrote in
message ...

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 the
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 in
Juni 2006

Hans


--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile:
http://www.excelforum.com/member.php...o&userid=20829
View this thread: http://www.excelforum.com/showthread...hreadid=497844