Trying to match the name in G11 to the name on the other tab called Timesheet in column E:E. If matches, then return the numbers in column D:D on the Timesheet tab that are not in Column H below. I need to know what numbers in H are missing from the Timesheet Tab from Column D:D if the names Match in G11 verse the timesheet column E:E. Hope I explain it right. Any help Apricated. Not sure the best way to do this has i will probably have more then one number returning for results or none.
Excel 2016 (Windows) 32 bit
Excel 2016 (Windows) 32 bit
F | G | H | |
---|---|---|---|
1 | |||
2 | |||
3 | 1 | ||
4 | 15 | ||
5 | 16 | ||
6 | 23 | ||
7 | 15 | ||
8 | 25 | ||
9 | 13 | ||
10 | 12 | ||
11 | F11 | 225 12 Street | |
12 | F12 | Formula here |
Sheet: Sheet1 |