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.

Formula help - Match & IF
 

"amdaman1" wrote:
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.

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

Thanks so much!!