Formula help - Match & IF
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.
|