Help Creating A Formula That Matches Values

[artiststevens]

Hello,
I need and formula that matches and values between a set of values in one row with values in another.

Criteria
>In column "AJ": I want the value from “AI” to be match with value between “I2:AH2” but only match with the heading of “MP” with the result being the number that is in the same row as the formula.

>In column "AK": I want the value from “AI” to be match with value between “I2:AH2” but only match with the heading of “P” with the result being the number that is in the same row as the formula.


Please see the attached spreadsheet self-calculated examples what I am trying to accomplish. Everything in the attached spreadsheet is calculated and entered by hand so it may contain errors. Thank you for any help you can provide it. Please feel free to ask any questions.

[Richard Buttrey]

Hi,

I'm assuming that's a typo in AG2 and it should be 13 not 14

In AJ2

Please Login or Register  to view this content.

and in AK2

Please Login or Register  to view this content.

both copied down.

[mike7952]

Try this is cell AJ3 and copy down

Please Login or Register  to view this content.

and this AK3 and copy down

Please Login or Register  to view this content.

[artiststevens]

Thank you both. The formulas you offered worked exactly the way I needed them to.

[Richard Buttrey]

My pleasure and thanks for the rep.