| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Index and match functions help needed.
I have the following column headings:
"Names" "Date" "Title Plan Reference Number" "Work Recording System" "Audit Stage" Now if I enter the name AND date i want the title to be automatiaclly displayed for the corresponding date and name that I have entered. I used the formula from the Excel help article that I read: =INDEX(A2:C4,MATCH(E2&F2,A2:A4&B2:B4,0),3). In theory having read the help article this is the formula I need. I have spent such a long time trying to get the formula to work but it wont. I need help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
| Match & Index | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
