Hello-
I have the following sample data set and I'm trying to return the appropriate column header based on criteria (i.e. DDD) and a number value which will be somewhere within the range of the table. In example below, the value returned should be Header 2 because the value is greater than those in Header 1 column (range H9 to L26). Any help greatly appreciated. Here's data table:
Criteria Header 1 Header 2 Header 3 Header 4
ZZZ 5.00 15.00 50.00 130.00
ZZ 5.00 15.00 50.00 130.00
Z 5.00 15.00 50.00 130.00
YYY 5.00 15.00 50.00 130.00
YY 5.00 15.00 50.00 130.00
Y 5.00 15.00 50.00 130.00
DDD 5.00 15.00 50.00 130.00
DD 5.00 15.00 25.00 75.00
D 5.00 15.00 20.00 65.00
RRR 5.00 15.00 15.00 45.00
RR 2.50 10.00 10.00 30.00
R 1.50 3.00 10.00 25.00
UUU 0.75 1.50 5.00 20.00
UU 0.75 1.50 5.00 20.00
U 0.75 1.50 5.00 20.00
P 0.75 1.50 5.00 20.00
T 0.10 0.10 5.00 18.00
Criteria Number Value
DDD 10.00 Header 1 >>>=INDEX($I$9:$L$9,MATCH(I29,INDEX($I$10:$L$26,MATCH(H29,$H$10:$H$26),)))
Bookmarks