| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Formula Help
Excel2003 ... I have the following Formula which is working fine:
=INDEX('Short Desc'!$E$2:$E$10000,MATCH(LEFT($C3,SEARCH(" ",$C3)-1),'Short Desc'!$D$2:$D$10000,0))&" "&E3 Issue is ... Formula is returning 1st occurance of the Match found in the Index ... So I need to check a 2nd criteria ("WS1 Col B" vs "Short Desc Col B"). How do I add this 2nd criteria? ... Thanks ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index Formula | Excel Worksheet Functions | |||
| Formula Help (IF) ... INDEX | Excel Worksheet Functions | |||
| If or index formula help | Excel Worksheet Functions | |||
| Index formula help | Excel Discussion (Misc queries) | |||
| Sum and Index formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
