| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index and Match Help
A B C D E F G
1 PRODUCT PRODUCT DATE CODE LOCATION RESULT 2 APPLES AP16063 3 4 5 6 PRODUCT MFG Product Date COLOR LOCATION 7 APPLES TREE AP16057 YELLOW XX001A 8 ORANGE TREE OA16098 ORANGE XX002A 9 APPLES TREE AP16063 RED XX003A 10 CHERRIES TREE CH16075 RED XX004A Formula needs to look up A2 and B2 from data and put the result into E3. I have tried multiple times index/match combo as an array and non-array formula and no luck. Any help would be appreciated. Sorry for the crudeness of a spreadsheet example. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
