Vertical lookup help needed
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 |
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 |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com