| Home |
| Search |
| Today's Posts |
|
#27
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS
Try this:
=--TRIM(RIGHT(SUBSTITUTE(TRIM(LOOKUP( 2,1/SEARCH(A4,Data!A4:A52),Data!A4:A52)) ," ",REPT(" ",255)),255)) -- Biff Microsoft Excel MVP "JingleRock" wrote in message ... Glenn, This is the link to my sample data: http://www.savefile.com/files/2038013 Also, refer to my comments about this file that I posted this afternoon. JingleRock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX and MATCH functions | Excel Worksheet Functions | |||
| Index and Match functions I think | New Users to Excel | |||
| INDEX & MATCH functions | Excel Worksheet Functions | |||
| Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' | Excel Worksheet Functions | |||
| Index and Match Functions | Excel Worksheet Functions | |||
Threaded Mode
