temp.xls | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
2 | |||||||
3 | SheetNames | RFA | CaseOfficer | ||||
4 | 323401685872 | ||||||
5 | 1 | [TeamSheet.xls]Alli | |||||
6 | 2 | [TeamSheet.xls]Becky | PWCSurname | PWCForename | |||
7 | 3 | [TeamSheet.xls]Charlee | TASKER | TONI | |||
8 | 4 | [TeamSheet.xls]Diane | |||||
9 | 5 | [TeamSheet.xls]Gerri | NRPSurname | NRPForename | |||
10 | 6 | [TeamSheet.xls]Jo | YOUNG | LUCY | |||
11 | 7 | [TeamSheet.xls]Kelvin | |||||
12 | 8 | [TeamSheet.xls]Laura | Private/PB | MEFISSUE | |||
13 | 9 | [TeamSheet.xls]Martin | Private | 22/12/04 | |||
14 | 10 | [TeamSheet.xls]Phil | |||||
15 | 11 | [TeamSheet.xls]Richard | BF | Clearance | |||
16 | 12 | [TeamSheet.xls]Rob | 00/01/00 | 0 | |||
17 | 13 | [TeamSheet.xls]Tanya | |||||
18 | PWCDOB | NRPDOB | |||||
19 | 00/01/00 | 00/01/00 | |||||
20 | |||||||
21 | E/RStart | NRPEmployer | |||||
22 | 00/01/00 | 0 | |||||
23 | |||||||
24 | |||||||
25 | |||||||
26 | 323401685872 | ||||||
27 | Resultsonsheet | Ineedtoreturntheresultof$H$2onselectedsheet | |||||
28 | |||||||
29 | [TeamSheet.xls]Kelvin | ||||||
30 | |||||||
Formulas |
I have this working really well, (thanks to Domenic for his help).
I need another formula that returns the content of $H$2 on the sheet that’s been selected for the other formulas (matching the sheet the content of (E4) is on).
This is were the users name is.
I’ve tried for ages, could some give me some help
Thanks
Kelly