Hi,
I have a master sheet with names on but I would like this to lookup the exact name which will appear numerous times on various sheets in column A&B & return any total figures that are in column D, this is all in the same workbook.
This is what the formula will be looking at across all sheets
<colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;" span="2">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;" span="5">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;">
<tbody>
</tbody>
Many thanks I advance
I have a master sheet with names on but I would like this to lookup the exact name which will appear numerous times on various sheets in column A&B & return any total figures that are in column D, this is all in the same workbook.
This is what the formula will be looking at across all sheets
Picked By | Round | Total Units | Target Rate by Round | Start | Finish | Sched Time (mins) | Actual Mins | |
Waleed Munawar | A | 852 | 28 | 30 | ||||
B | 278 | 28 | 10 | |||||
Alex Ashton | D | 241 | 28 | 9 | ||||
Ethan Tye | Waleed Munawar | E | 359 | 28 | 13 | |||
Alex Ashton | F | 1053 | 28 | 38 | ||||
Ethan Tye | Leah Curwen | G | 54 | 28 | 2 | |||
P | 0 | 28 | 0 | |||||
T | 615 | 28 | 22 | |||||
GREENS | 785 | 28 | 28 |
Many thanks I advance