| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT & VLOOKUP functions
Hi, I hope someone can help me, several of you helped me with this problem
earlier and I am finding however that the following formula does not update? Rolls!A4 contains the following formula =INDIRECT((VLOOKUP(B2,D41:F50,3,TRUE))&"!A5") What I am trying to achieve: I have 10 worksheets with a list of students names on each. the Vlookup formula refers to an index [D41:F50] containing the following information: className Teacher sheet Eg. 9ISTX Mrs Duffy 1 Any assistance would be appreciated. Regards tanya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| indirect.ext / pull functions | Excel Discussion (Misc queries) | |||
| Sumproduct & Indirect Functions | Excel Worksheet Functions | |||
| row-indirect functions | Excel Discussion (Misc queries) | |||
| Offset and Indirect functions | Excel Discussion (Misc queries) | |||
Threaded Mode
