G
Guest
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
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