2 vlookup criterias
 

Example sheet:

a CYCLES 0.207 0.218 0.225
b 10000 212 247 268
c 12500 203 237 257
d 15000 196 229 249
e 17500 190 221 240
f 20000 185 215 234

...
0.207, 0.218, 0.225 are wire diameters. I'm making a conversion tool. The numbers in fields B2:F4 are stress figures. My goal is to return a 'Cycles' value in a seperate cell.

Example, I have a 0.218 with 235 stress level. How do I get this to recognize the greater 237 value in the table and return a 12500 value in the necessary cell?

Thanks in advance for any help.

BD

Return a Header Value with 2 vlookup criteria
 

hi BD,

if data in columns C, D and E are always sorted in descending order

=INDIRECT(ADDRESS(MATCH(235,OFFSET(INDIRECT(ADDRES S(2,MATCH(0.218,A1:E1,0))),,,5,1),-1)+1,2))

--
isabelle



Le 2012-07-11 11:29, BDAvs a écrit :
a CYCLES 0.207 0.218 0.225
b 10000 212 247 268
c 12500 203 237 257
d 15000 196 229 249
e 17500 190 221 240
f 20000 185 215 234

..
0.207, 0.218, 0.225 are wire diameters. I'm making a conversion tool.
The numbers in fields B2:F4 are stress figures. My goal is to return to
a 'Cycles' value in a seperate cell.

Example, I have a 0.218 with 235 stress level. How do I get this to
round to the 237 value in the table and return a 12500 value in the
necessary cell?

Thanks in advance for any help.

BD