INDEX MATCH MATCH gives N/A without row numbers defined

Hi All,
First time poster so forgive any unintentional forum rudeness. I'm using INDEX MATCH MATCH with OFFSET to find a value, then find a text string on the row of that value, and return the contents of the cell to the right of the cell containing the text. The text string is a value in the data set, is not in the column header, and it may be in any one of five different columns. INDEX MATCH MATCH works as long as I plug the specific row into the second MATCH criteria, but I can't figure out a way to specify the correct row to locate the text string on that row. On the plus side, I will always be looking for the same text string (i.e. "AUX")

The workbook sample may illustrate this better than my description. Index statement is in cell B14.

Example: For item A5678 (A7), I want to find the Position ID (G7) for the AUX position (Column F, but could be in columns B, D, F, H, or J). I get a valid result if I add the row number to the second match:

Please Login or Register  to view this content.

How do I indicate the row number dynamically for all rows?

Thanks in advance for any help.

Thank you Martin and Biff. Both options worked great!