For this challenge we were required to extract some information (Bulk and Retail price) from a data sheet, using the VLOOKUP for it. Besides the logical I opted to tweak it a little bit by using the IFERROR formula to output a standard message for when a value wasn’t found, which I defined as “value not found”. That’s pretty silly and it doesn’t make much difference, it’s just better than the usual #N/D for error checking purposes, especially when dealing with a lot of data – not the case for this challenge though.
