Create an invoice - extracting data from a excel sheet (table)

[annaisakiwi]

HI all

I'm wanting to extract data from a sheet to make up an invoice. I want to match the name and date in my invoice sheet, and then pull through data.

So choose name - Kaden, Date 10 April, and have all the specified columns of data and rows come through.

What formula should I be looking at? I'm feeling very lost!

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is that a 'formal' Excel table (Insert ribbon tab -> Table)?
If so, what is the name of the table?

 

[annaisakiwi]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is that a 'formal' Excel table (Insert ribbon tab -> Table)?
If so, what is the name of the table?

Thanks - have updated my account details (it's been a while since i've been here!)
I'm using 365.

Yes it's a formal excel table - named Maxtedtbl2

 

[Peter_SSs]

Thanks for updating your details & the table info.

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

See if this is the sort of thing that you want. (It doesn't have to be on the same worksheet)

annaisakiwi.xlsm
	A	B	C	D	E	F	G	H	I	J
1		Type	Name	Date	Data 1	Data 2	Data 3	Data 4	Data 5	Data 6
2		a	Kaden	27-Mar	156	340	891	985	335	270
3		a	Kaden	28-Mar	574	834	289	525	338	447
4		a	Kaden	29-Mar	549	650	255	172	985	931
5		a	Kaden	30-Mar	523	332	261	152	249	432
6		a	Kaden	31-Mar	959	962	701	301	575	251
7		a	Kaden	1-Apr	758	703	415	808	922	222
8		a	Kaden	2-Apr	195	578	155	627	517	667
9		a	Anna	27-Mar	701	304	195	478	222	558
10		a	Anna	28-Mar	494	906	110	440	243	453
11		a	Anna	29-Mar	328	781	387	926	234	350
12		a	Anna	30-Mar	845	718	418	834	116	287
13		a	Anna	31-Mar	321	118	183	230	889	135
14		a	Anna	1-Apr	131	901	938	346	557	645
15		a	Anna	2-Apr	110	389	384	822	751	464
16
17
18
19
20	Name	Kaden
21	Date	29-Mar
22		a	Kaden	29-Mar	549	650	255	172	985	931
23
Sheet1

Cell Formulas
Range	Formula
B22:J22	B22	=FILTER(Maxtedtbl2,(Maxtedtbl2[Name]=B20)*(Maxtedtbl2[Date]=B21),"")
Dynamic array formulas.

 

[annaisakiwi]

Sorry Peter, thought I had replyed to this - thanks heaps, exactly the help I needed to set me off in the right direction

 

[Peter_SSs]

You're welcome. No problem with the late reply, better late than never.