0 Vlookup Value

[Tufail]

hello
i am using following vlookup, but when there isn't lookup value then coming
out O which i don't want !

=IF($J15="","",IF(ISNA(VLOOKUP($J15,Header3,2,)),"",VLOOKUP($J15,Header3,2,)))

thanks in advance.

 

[Mike H]

You don't say what you do want so this returns a blank the same as your ISNA
result.


=IF($J15="","",IF(ISNA(VLOOKUP($J15,Header3,2,)),"",IF(VLOOKUP(J15,Header3,2)="","",VLOOKUP(J15,Header3,2))))

Mike

 

[Tufail]

oh sorry ! but it's working, thank you very much .