ExcelBanter - Vlookup

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup (https://www.excelbanter.com/excel-worksheet-functions/66423-vlookup.html)

Fletch

Vlookup

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks

Sloth

Vlookup

surround your formula like this

=IF(ISERROR(formula),"",formula)
or
=IF(ISERROR(formula),"not in list",formula)

"Fletch" wrote:

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks

Fletch

Vlookup

It works perfectly - Thank You!

"Sloth" wrote:

surround your formula like this

=IF(ISERROR(formula),"",formula)
or
=IF(ISERROR(formula),"not in list",formula)

"Fletch" wrote:

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks

All times are GMT +1. The time now is 04:40 AM.