Example.png
Hi, I got a semi hard one today :D
I have two columns with amounts and percentages and a third column for my return values.
I have a chart with a header range of:
0-60.00
60.01-65.00
65.01-70.00
70.01-75.00
75.01-80.00
80.01-85.01
..and header row of:
10000-34999
35000-49999
50000-74999
75000-99999
100000-150000
150001-350000
350001-500000
500001>
What I want to do is have a formula identify the amount in cell A2 and percentage in B2 and find the intersection value in the two ranges.
Bookmarks