I have a file with two sheets. On the 1st, I have dollars in O13and in O16 a number signifying 1-6 people.
On the second workbook is a matrix that corresponds to the dollar amount AND the number of people. For example, sheet 1 O13 is $6,000. O16 is 3. I want a formula to find $6,000 (not higher) on sheet 2 in column A. Then I want it to compare sheet 1 O16 to the correct column (B-G representing 1-6) on sheet 2 for an exact match to place in sheet1 O17.
The range of sheet1 O13 is referenced on sheet2 A5-A383, and sheet 1 O16 is referenced on sheet2 B5:G383.
I have an INDEX Match but it isn't quite working, yet.
Solved by B. B. in 60 mins