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

	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

 

[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?