Search rows in a table with uneven rows

1. Search rows in a table with uneven rows

A B C D E F
1 A B C D E
2 40 5 15 25 30 40
3 50 0 10 15 25
4 60 0 10 15
5 70 0 5

user input 1 (refers to column A): 50
user input 2 (refers to a value in the table associated with user input1): 17

The table above is an example of that data I'm working with. What I want to do is, based upon user input1 and user input2, find the corresponding letter. In this example, user input1 is 50 so row 3 is selected. User input2 is 17. Find an equal or next largest value in row 3. That would be 25 and the corresponding letter is D.

I know how to do this with rows of equal length but not unequal.

2. Re: Search rows in a table with uneven rows

Assuming your table is in C1:H5 with header letters starting at D1 and vertical numbers starting at C2, And A1, B1 contain your inputs...then try:

=INDEX(\$D\$1:\$H\$5,1,MATCH(TRUE,INDEX(\$D\$2:\$H\$5,MATCH(A1,\$C\$2:\$C\$5,0),0)>=B1,0))

confirmed with CTRL+SHIFT+ENTER not just ENTER

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1