Multiple condition vlookup & matching

Static Data

A1:A12 - name range - "XYZ"
Columns B to G (B1:G12) - has numbers (without decimal)

(B & C column cells contain some data for 1 to 10 days
D & E - column cells contain some data for 11 to 21 days
F & G - column cells contain some data for 22 to 32 days


Input & Result

H1 - a dropdown list referring to "XYZ" name range
I1 - Input data 2 digits max (cell is formatted as number & max value is 1 to 32)
J1 - Result1
K1 - Result2


My Question is

In H1 some value is selected from dropdown, then in I1 a number (1-32) is entered.

For instance, the selection is A1 & the number is 1
J1 should show b1 & K1 should show C1.

If the entered number is 12, then J1 should show D1, & K1 should show E1

Hope my question is clear.

Better if you attach a sample workbook showing what you need.

Thanks, I attached a file Text.xls.

But this is not a sample, i am doing this as new.

See attached...

If I understood you correctly, formula in J1 would be:

=INDEX($A$1:$G$12,MATCH(H1,XYZ,0),$I$1)

and formula in K1 would be:

=INDEX($A$1:$G$12,MATCH(H1,XYZ,0),$I$1+1)

these will extract the numbers in the row that the input in H1 is found in and at the column number indicated by I1 and the column next to that...

Also, I added a data validation to I1 that would force users to enter an even number only... as I think this makes sense.. you don't want them to enter 1, 3, 5, 7, etc in I1, do you? To see the validation test, select I1 and go to Data|Validation.

Try these in J1 and K1, respectively:

=INDEX($A$1:$G$12,MATCH($H$1,XYZ,0),LOOKUP($I$1,{1,11,21},{2,4,6}))

=INDEX($A$1:$G$12,MATCH($H$1,XYZ,0),LOOKUP($I$1,{1,11,21},{3,5,7}))