Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"Vlook up + IF"
I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid have some cells N/A instead of a number (zero). How I could do that? thanks in advance for your help, Paula |
#2
|
|||
|
|||
One way:
=IF(ISERROR(yourVLOOKUPfunction),"",yourVLOOKUPfun ction) This would make the cell look empty instead of showing the error. It would not fix the error, though. tj "paula smith" wrote: I have created a function "vlook up" which worked fine, however I would like to add the function "if" to avoid have some cells N/A instead of a number (zero). How I could do that? thanks in advance for your help, Paula |
#3
|
|||
|
|||
Paula,
using if(isna would trap NAs =IF(ISNA((VLOOKUP(A2,A3:B6,2,FALSE))),"",VLOOKUP(A 2,A3:B6,2,FALSE)) Regards, Rob "paula smith" wrote in message ... I have created a function "vlook up" which worked fine, however I would like to add the function "if" to avoid have some cells N/A instead of a number (zero). How I could do that? thanks in advance for your help, Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) |