Formula help - Match & IF

[amdaman1]

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 hav
the names. I want the cell value to change based on the name that's i
the cell if it matches the name range.

I came up with this but it only shows the right value if the name is o
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

 

[joeu2004]

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)

 

[amdaman1]

Basically I have a list range of names and then in another column have
the names. I want the cell value to change based on the name that' in
the cell if it matches the name range.
I came up with this but it only shows the right value if the name i 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!