how to clear #NA error in VLOOKUP

[kimjoybarclay]

=IF(B7="","",VLOOKUP(B7,ProductLookup,3,FALSE)) this is the formula I am using. I am using it on an order form that will be repeatedly cleared and re-filled in for students during registration. However, when the textbook is cleared from the "Products" column, this error report shows up in the Course and Price Columns. How do I report a blank in those cells when the Textbook (Product) is removed?

 

[mrhstn]

Try

=IF(B7="","",IFNA(VLOOKUP(B7,ProductLookup,3,FALSE), ""))

Or

=IF(B7="","",IFERROR(VLOOKUP(B7,ProductLookup,3,FALSE), ""))

 

[kimjoybarclay]

The first one worked perfectly! Thank you so much!!!!]