Vlookup

  • Thread starter Thread starter HS
  • Start date Start date
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!
 
Try this:

=IF(VLOOKUP(B3,Data!A1:L1602,12,0)="","",VLOOKUP(B3,Data!A1:L1602,12,0))
 
You must log in or register to reply here.

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 autofill for multiple worksheets 0
vlookup 6
EXCEL - IF(IFERROR(VLOOKUP question 0
Combining IF Statement and Vlookup 0
IF function 2
Vlookup 2
Referring to a cell by using another cell for the row number 6

Back
Top