I am having issues with finding a specific value based on multiple criteria and the criteria needs to be searched into multiple rows and columns. I have tried using match, index, if, row functions but nothing worked. I have included an attachment with an example and also posed the question. Hope that helps. If you look at the example, I am basically trying to find the value of the goods that matches the company name, and also matches the states in row 1 and Col B. I know how to use the match function to find the row number and col number for the criteria but i have multiple cols that needs to be looked into for the criteria and that is where I am failing. Please help.
Bookmarks