Using arrays alongside INDEX and MATCH

The flow of this macro is to take a value, search for that value within a range, and record the offsetting value of the second row of the specified column.

The length of each range is the number of cells merged in each respective "FIELD" in row one.

For example, FIELD A is 3 cells, FIELD B is 3 cells, FIELD C is 2 cells, FIELD D is 4 cells, FIELD E is 2 cells, FIELD F is 4 cells, FIELD G is 24 cells, FIELD H is 9 cells, and FIELD I is 15 cells.

Starting in column BO, the target value is every other column.

For example, take the target value in cell BO3 and look inside the range A3:AC3, a match is found in cell C3, and the offsetting same column row 2 value is C - which goes in cell BP3.

Another example, take the target value in cell BQ3 and look inside the range D3:DF3, a match is found in cell E3, and the offsetting same column row 2 value is E - which goes in cell QR3.

(note, FIELD B is included twice)

Another example, take the target value in cell CE3 and look inside the range AQ3:AY3, a match is found in cell AY3, and the offsetting same column row 2 value is AM which goes in cell CF3.

Each search(look-up value) is to take place within its own range.

Now, I could have 10 different MATCH/INDEX lines of code, but (if possible) I would like a single (or a few lines) which I'm guessing incorporates an array which redefines the length of the search range.

Another way to look at this is, each look-up value matches up to a field (the text in row one indicates which field), and the search range for that look-up value is the same field.