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.
Bookmarks