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