I'm hoping someone can help me figure this out. Essentially, here is what I'm trying to accomplish using a formula: In cell N2, look for matches to M1 value in column B, then within these matches, look for a match to M2 value in column C. Then, given that a combination of these 2 criteria is found, make the following calculation : [(column D value on the right of two criteria match)/L1]*(column E value on the right of two criteria match)
Then the idea would be to drop this formula down the N column so that it adapts to changing values in the M columns, depending on a choice made in M1.TEST1.xlsx
I've attached a spreasheet example. Thanks for your help with this!