Hi everyone,
I am using the following formula to look up part numbers. Basically, I am typing the part number I want to find into cell C2, which is intended to look up product prices and margins on a different sheet.
=INDEX('2017 RRP Price List'!C$2:C$9999,MATCH(Lookup!C$2,'2017 RRP Price List'!A$2:A$9999))
The problem is that, if for example I type in part number 1234 but this does not exist on the price list sheet, it will return data related to part number 1233. The user would have no way of knowing that the information is incorrect (unless they were to manually check the product prices sheet).
Ideally, if the part number is not found, I would like cell C2 to show "NOT FOUND".
Can anyone help me with this?
Bookmarks