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]

It doesn't make you do anything, you need to click Mini Sheet

 

[zone709]

it doesn't make me click it. The tab is not highlighted to work. Do i need to do something in excel so i can click Mini Sheet?

 

[Fluff]

Have you tried what it says in this post XL2BB Disappears when Excel is Reopened

 

[zone709]

Yes and my tab is always there Xl2bb. It never disappears. I just cant click on Mini Sheet or Table Only

 

[Fluff]

But have you put the file in a trusted location and/or unblocked it?

 

[zone709]

I been trying everything. I even went to File Explorer and right click No general Tab. I am either doing something wrong or its something else. Is there walk through instructions on this. I already clicked the link you sent me and i went through those steps.

 

[Fluff]

Try

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

 

[zone709]

Try

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

Ok this formula works thanks very Much. Now i am going to try and figure out how to get this Mini Sheet to work.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[zone709]

Hi sorry if it doesn't find a number missing. I get in return #CALC!. Anyway for this not to happen and just to return blank?