ExcelBanter - vlookup

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/246276-vlookup.html)

vlookup appearance

vlookup

i am using vlookup to set up a register.i wish to have the empty cells that
contain vlookup formula NOT to show #ref or #n/a untill i need to enter a
data from a list
i wish to use this as a way to input new entries and vlookup adds the
corresponding data from a list

Mike H

vlookup

Hi,

Maybe this

=IF(ISERROR(your lookup formula),"",your lookup formula)

Mike

"vlookup appearance" wrote:

i am using vlookup to set up a register.i wish to have the empty cells that
contain vlookup formula NOT to show #ref or #n/a untill i need to enter a
data from a list
i wish to use this as a way to input new entries and vlookup adds the
corresponding data from a list

All times are GMT +1. The time now is 05:54 AM.