| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is INDEX,MATCH the best way?
here is the problem:
A B C 1 Apple .40 =Index(A1:A5,Match(Large(B1:B5,1),0)) (Returns-Peach) 2 Orange .30 =Index(A1:A5,Match(Large(B1:B5,2),0)) (Returns-Apple) 3 Banana .20 =Index(A1:A5,Match(large(B1:B5,3),0)) (Returns-Apple) 4 Pear .40 =Index(A1:A5,Match(Large(B1:B5,4),0)) (Returns-Orange) 5 Peach .50 =Index(A1:A5,Match(Large(B1:B5,5),0)) (Returns-Banana) Is there a way to have the formula in C3 return Pear? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| Index or Match or what? | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
