Try this:

=IF(VLOOKUP(B3,Data!A1:L1602,12,0)="","",VLOOKUP(B 3,Data!A1:L1602,12,0))

--
Biff
Microsoft Excel MVP


"HS" wrote in message
...
Is it possible to do a vlookup and when the corresponding cell is empty
that
it display nothing rather than a 0?

=VLOOKUP(B3,Data!A1:L1602,12,FALSE)

thank you!