Formula help. Match name return numbers that not in Column H

[zone709]

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
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td][/td][td][/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td][/td][td][/td][td]

15​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td][/td][td][/td][td]

16​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td][/td][td][/td][td]

23​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td][/td][td][/td][td]

15​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td][/td][td][/td][td]

25​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td][/td][td][/td][td]

13​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td][/td][td][/td][td]

12​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td]F11[/td][td]225 12 Street[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td]F12[/td][td=bgcolor:#FFFF00]Formula here[/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[Fluff]

How about

=LET(f,FILTER(Sheet2!D2:D1000,Sheet2!E2:E1000=G11,""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))

 

[zone709]

Hi Is there anyway to add more columns to this formula to check more then E2:E1000. The D2:D1000 still stays the same.

Like this E2:E1000 G2:G1000 I2:I2000 etc. How can i add this to this formula if i can in this part --- Sheet2!E2:E1000=G11,""

 

[Fluff]

What should those other columns check against?

 

[zone709]

What should those other columns check against?

The same in the Formula H3:H11 if the names match. So like E G I check verse H if name matches. Instead of just E on the original.

 

[Fluff]

Sorry, that makes no sense to me.
The criteria for col E is G11, so what is the criteria for the other columns?

 

[zone709]

Look at the first job that in column E way below, Then there is Jobs in f and g. So if E doesn't match G11 maybe F and G will and return the number in D on timesheet that isn't in column H.

Instead of me doing this below over and over.

=LET(f,FILTER(Timesheet!D2:D1000,Timesheet!E2:E1000=G11,""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))

=LET(f,FILTER(Timesheet!D2:D1000,Timesheet!F2:F1000=G11,""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))

=LET(f,FILTER(Timesheet!D2:D1000,Timesheet!G2:G1000=G11,""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))

Trying to add something like this if possible.
=LET(f,FILTER(Timesheet!D2:D1000,Timesheet!E2:E1000,F2:F1000,G2:G1000=G11,""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))
But that's not working.



Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]

ID​

[/td][td]

JOB​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]

1​

[/td][td=bgcolor:#00B0F0]

11th street​

[/td][td=bgcolor:#F8CBAD]

205 5th street​

[/td][td=bgcolor:#00B0F0]

225 12 Street​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Timesheet[/td][/tr][/table]

 

[Fluff]

Try

=LET(f,FILTER(Timesheet!D2:D1000,(Timesheet!E2:E1000=G11)+(Timesheet!F2:F1000=G11)+(Timesheet!G2:G1000=G11),""),FILTER(f,ISNA(MATCH(f,H3:H10,0)),""))

 

[zone709]

Perfect thank you. I didn't know i have to add it like that hanks.

 

[Fluff]

My pleasure.