| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX AND MATCHING FUNCTIONS
Your welcome and thanks for the feedback
"Jeanette" wrote: Mike: thanks very much it worked beautifully! -- Thanks, Jeanette "Mike H" wrote: Jeanette, Try this =INDEX(A1:D5, MATCH(99,A1:A5,0), MATCH(0.9,A1:D1,0)) in practice I'd use cell references for the lookup values Mike "Jeanette" wrote: Hi hoping someone can help. I've read through various posts and I am still a bit confused. I want to return the value of a PIR of 98 and an IPF of 0.8 (6.6%) IPF 0.7 0.8 0.9 PIR 100 6.00% 7.00% 8.00% 99 6.20% 6.80% 7.80% 98 5.80% 6.60% 7.60% 97 5.60% 6.40% 7.40% -- Thanks, Jeanette |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Matching in combination w/Right() | Excel Worksheet Functions | |||
| index and matching with string search! | Excel Worksheet Functions | |||
| index and matching in userform! | Excel Discussion (Misc queries) | |||
| Index/ Lookup formulas and fuzzy matching | Excel Worksheet Functions | |||
| Index & Matching Functions | Excel Discussion (Misc queries) | |||
Threaded Mode
