| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 Last edited by BDAvs : July 12th 12 at 05:21 PM Reason: Title |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Header | Excel Discussion (Misc queries) | |||
| return row header as answer | Excel Programming | |||
| look up X and return a header Y | Excel Discussion (Misc queries) | |||
| vlookup to return the cell positioning where the criteria is found | Excel Programming | |||
| VBA Syntax for VLOOKUP to return array of return values | Excel Programming | |||
Linear Mode
