Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
Match formula to match values in multiple columns | Excel Programming | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions |