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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel IF statement with vlookup 2
vlookup 6
Vlookup autofill for multiple worksheets 0
Combining IF Statement and Vlookup 0
Looking for IF with VLOOKUP statement with two conditions. 6
Vlookup 2
IF function 2
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1

Top