If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
match and vlook up | andy | Worksheet Functions | 4 | April 1st, 2004 12:34 PM |
i can't understand how to make a success vlook up | Mr Wright | Worksheet Functions | 2 | October 8th, 2003 10:42 AM |
Vlook problems | Mark h | Worksheet Functions | 2 | October 8th, 2003 07:43 AM |