ExcelBanter - Vlookup

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Vlookup (https://www.excelbanter.com/new-users-excel/233328-vlookup.html)

HS[_2_]

Vlookup

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. Valko

Vlookup

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!

HS[_2_]

Vlookup

perfect :) thank you

"T. Valko" wrote:

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!

T. Valko

Vlookup

You're welocme. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

"HS" wrote in message
...
perfect :) thank you

"T. Valko" wrote:

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!

All times are GMT +1. The time now is 03:11 PM.