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

 

[hajiali]

Can you post the sheet names Timesheet. What the results you are expecting.

 

[Fluff]

How about

=FILTER(H3:H11,ISNA(MATCH(H3:H11,FILTER(Sheet1!D2:D1000,Sheet1!E2:E1000=G11),0)))

 

[zone709]

How about

=FILTER(H3:H11,ISNA(MATCH(H3:H11,FILTER(Sheet1!D2:D1000,Sheet1!E2:E1000=G11),0)))

Hi so i changed it to Timesheet which where D:D and E:E are , but it returns 0. It should of returned 2 numbers that were missing from column H.

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

If you see the last 2 numbers 49 & 62 should of returned because they are not in Column H and column E matches G11 address 225 21 Street.

Excel 2016 (Windows) 32 bit

	D​	E​
6​	​	​
7​	ID​	JOB​
8​	1​	225 12 Street​
9​	15​	225 12 Street​
10​	10​	205 5th street​
11​	12​	Place Street​
12​	16​	225 12 Street​
13​	23​	225 12 Street​
14​	15​	225 12 Street​
15​	25​	225 12 Street​
16​	13​	225 12 Street​
17​	12​	225 12 Street​
18​	49​	225 12 Street​
19​	62​	225 12 Street​

Sheet: Timesheet

 

[Fluff]

Can you please post data from both sheets using the XL2BB add-in.

 

[zone709]

Can you please post data from both sheets using the XL2BB add-in.

I am just looking for numbers that are not in Column H, but are in Column D from timesheet if address matches next to it. Doesnt matter how many times the numbers are on the timesheet. Just need to know what i am missing.

Excel 2016 (Windows) 32 bit

	F​	G​	H​	I​
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		Should return numbers 49 & 62 from timesheet. As they are not in column H

Sheet: Sheet1

Timesheet from other Tab

Excel 2016 (Windows) 32 bit

	D​	E​
5​	​	​
6​	​	​
7​	ID​	JOB​
8​	1​	225 12 Street​
9​	15​	225 12 Street​
10​	10​	205 5th street​
11​	12​	Place Street​
12​	16​	225 12 Street​
13​	23​	225 12 Street​
14​	15​	225 12 Street​
15​	25​	225 12 Street​
16​	13​	225 12 Street​
17​	12​	225 12 Street​
18​	49​	225 12 Street​
19​	62​	225 12 Street​

Sheet: Timesheet

 

[Fluff]

Can you please use the XL2BB add-in, not Forum Tools or what ever you are using.

 

[zone709]

Can you please use the XL2BB add-in, not Forum Tools or what ever you are using.

I have copy range under Forum Tools. When i go under tab Xl2bb in the section Capture Range. It doesn't make me click Mini Sheet or Table Only if that's what you are looking for me to do?

 

[Fluff]

Select the range & click the Mini-sheet option.

 

[zone709]

Select the range & click the Mini-sheet option.

ok its not making me click the Mini Sheet tab after i select range. Not sure why.