ExcelBanter - how to get rid of #N/A when not use on vlookup

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

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

- - how to get rid of #N/A when not use on vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/136349-re-how-get-rid-n-when-not-use-vlookup.html)

Curtis

how to get rid of #N/A when not use on vlookup

Thanks a lot that really helped.
"pinmaster" wrote:

Hi,

Try this:

=IF(A1="","",VLOOKUP(A1,Sheet2!A4:H100,3,0))

HTH
Jean-Guy

"Curtis" wrote:

I have a data set up using vlookup everything works great except if I have a
cell thats blank for the roll shows #N/A, if I put the product code in blank
it does what its suppose to do but if left blank it shows #N/A how to get rid
of it? I try
( = vlookup(A1=0,"", A1,sheet2!a4: h100,3,false ) but that doesnt work,
any help on this?

All times are GMT +1. The time now is 09:17 AM.