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
|
|||
|
|||
isna vlookup
Hi
I'm using this vlookup to get values from a sheet named "sub": VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE) and t works. But when "R1" is not in the lookup table sub!$J$1:$K$18 I get an #N/A as a result and I changed the vlookup formula to: =IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE),"",VLO OKUP (R1,sub!$J$1:$K$18,2,FALSE)) to avoid #N/A but now I receive an error message for the formula. Is there anybody who knows how to fix this problem? |
#2
|
|||
|
|||
Tim wrote:
Hi I'm using this vlookup to get values from a sheet named "sub": VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE) and t works. But when "R1" is not in the lookup table sub!$J$1:$K$18 I get an #N/A as a result and I changed the vlookup formula to: =IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE),"",VLO OKUP (R1,sub!$J$1:$K$18,2,FALSE)) to avoid #N/A but now I receive an error message for the formula. Is there anybody who knows how to fix this problem? A paren is missing: =IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE)),"",VL OOKUP (R1,sub!$J$1:$K$18,2,FALSE)) |
#3
|
|||
|
|||
Thank you Aladin.
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ISNA and VLOOKUP | Chris Kellock | Worksheet Functions | 3 | March 12th, 2005 07:05 AM |
Problem with vlookup and isna function | Frank Kabel | Worksheet Functions | 1 | April 10th, 2004 11:20 AM |
IF ISNA VLOOKUP problem | Alby | Worksheet Functions | 3 | March 25th, 2004 12:41 PM |