Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function yielding a #N/A result
Due the size restriction of the IF function, I have used the LOOKUP function
for my conditional formula. It is yielding the results I want, but when the criteria does not match, the result is the error #N/A. Here is the formula I am using: =LOOKUP(B4,{"Name1","Name2","Name3","Name4","Name5 ","Name6","Name8","Name9"},{"#1 VIP","#2 VIP","VIP","VIP","VIP","VIP","VIP","VIP"}) Is there anyway to use the IF function so that if the result of the above formula = #N/A, the cell is blank. Or can I set a conditional format so that if it's #N/A, the cell is highlighted or font color different? Also, with this same formula, is it possible to have the LOOKUP reference more than 1 cell (i.e. =LOOKUP(B4 &" "& B5, . . . .)? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I turn the #N/A result from a lookup function to a zero? | Excel Worksheet Functions | |||
Lookup for more than one result | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
I need a Lookup to return more than 1 result | Excel Worksheet Functions | |||
Unwanted LOOKUP() Result | Excel Discussion (Misc queries) |