Hello Excel Community,
I have been fiddling with my Index & Match formula and it is not returning the right result. I am more than likely missing something very obvious and I am just not seeing the error. I want the formula to return a 1 if true and text when not; I have also included an iferror statement if there is no criteria matching the scenario. In am looking up if a header in sheet 2 and a product number can be found in sheet 1 in columns a and b then return a 1. Hopefully the attached sheet will make more sense.
Thank you all for your time.
Bookmarks