kimjoybarclay
New Member
- Joined
- Aug 16, 2017
- Messages
- 2
=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?