|
| 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
November 28th, 2004, 03:09 PM
|
|||
|
|||
"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
November 28th, 2004, 03:19 PM
|
|||
|
|||
|
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
November 28th, 2004, 03:20 PM
|
|||
|
|||
|
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 |
Linear Mode
