I have 4 columns of data in the attached workbook and I attempted to use INDEX MATCH to retrieve values in column F based on the value in cell J4. The right formula would look in range C2:E24 and return the corresponding value in column F. For example, I would like the formula to look in the range for SA853 and return 400 as the answer. My thought was to return the row number SA853 was located in and use INDEX in column F to retrieve the answer, but wasn't successful piecing them together. Thank you for your help!
Bookmarks