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

"Mike H" wrote:

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,Head er3,2))))

Mike

"Tufail" wrote:

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.