Vlookup

H

HS

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!
 
T

T. Valko

Try this:

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