Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following simple example:
test1 results test2 test3 A B C D 1 dl 1 dl 2 th 12 gf 3 #N/A 13 ty 4 #N/A 1 up 5 vy 14 ar 6 #N/A 99 tn 7 de 7 de 8 #N/A 2 th 9 #N/A 5 vy I want to use the value in col A, search table C&D and put the result in B. The formula I am using is =VLOOKUP(A6,$C$4:$D$12,2,FALSE). I am getting the #n/a error. How do i eliminate the #N/A message with a 0 or blankcell? Thanks |
#2
![]() |
|||
|
|||
![]()
Hi
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) -- Regards Frank Kabel Frankfurt, Germany Have three columns R,S,T wrote: I have the following simple example: test1 results test2 test3 A B C D 1 dl 1 dl 2 th 12 gf 3 #N/A 13 ty 4 #N/A 1 up 5 vy 14 ar 6 #N/A 99 tn 7 de 7 de 8 #N/A 2 th 9 #N/A 5 vy I want to use the value in col A, search table C&D and put the result in B. The formula I am using is =VLOOKUP(A6,$C$4:$D$12,2,FALSE). I am getting the #n/a error. How do i eliminate the #N/A message with a 0 or blankcell? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to lookup data in a row and column | Excel Discussion (Misc queries) | |||
need check two worksheets to lookup a value | Excel Discussion (Misc queries) | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |