Hi guys,

I seem to be stumped with this one and it's probably pretty simple.

Basically I have a list range of names and then in another column I have the names. I want the cell value to change based on the name that's in the cell if it matches the name range.

I came up with this but it only shows the right value if the name is on the list, otherwise it displays N/A;

=IF(MATCH($A8,$W$4:$W$10,0),U8,V8)

It seems to ignore the V8 argument.

Any help appreciated.

Cheers.