0 Vlookup Value

T

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.
 
M

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
 
Top