Multiple criteria row look-up from database on separate sheet

[Ewan11]

I'm looking to see if i can "pull" data from a database in a separate sheet onto another sheet using specific Criteria e.g.

[TABLE="width: 554"]
<tbody>[TR]
[TD="colspan: 5"]Search Criteria [/TD]
[/TR]
[TR]
[TD]Teacher[/TD]
[TD]Venue[/TD]
[TD]DAY[/TD]
[TD]TIME[/TD]
[TD]Attending[/TD]
[/TR]
[TR]
[TD]Ewan[/TD]
[TD]Swimming Pool 1[/TD]
[TD]Thursday[/TD]
[TD]6:00 PM[/TD]
[TD]yes[/TD]
[/TR]
</tbody>[/TABLE]


Matching results displayed below: I.e. copy rows from data base that match the above criteria.

[TABLE="width: 1544"]
<tbody>[TR]
[TD="class: xl65, width: 110"]Teacher[/TD]
[TD="class: xl65, width: 114"]Venue[/TD]
[TD="class: xl65, width: 110"]DAY[/TD]
[TD="class: xl65, width: 110"]TIME[/TD]
[TD="class: xl65, width: 110"]Attending[/TD]
[TD="class: xl65, width: 110"]PHONE NUMBER[/TD]
[TD="class: xl65, width: 110"]secondary contact[/TD]
[TD="class: xl65, width: 110"]Emergency contact[/TD]
[TD="class: xl65, width: 110"]EMAIL ADDRESS[/TD]
[TD="class: xl65, width: 110"]DOB[/TD]
[TD="class: xl65, width: 110"]Age[/TD]
[TD="class: xl65, width: 110"]Days until Birthday[/TD]
[TD="class: xl65, width: 110"]FIRST NAME[/TD]
[TD="class: xl65, width: 110"]SURNAME[/TD]
[/TR]
</tbody>[/TABLE]

 

[Smitty]

Welcome to the Board!

One way is to use a helper column in each data set concatenating all of your fields, then VLOOKUP on that.

Excel 2012
	A	B	C	D	E	F	G	H	I	J
1	Concat	Teacher	Venue	DAY	TIME	Attending	PHONE NUMBER	secondary contact	Emergency contact	EMAIL ADDRESS
2	EwanSwimming Pool 1Thursday0.75yes	Ewan	Swimming Pool 1	Thursday	6:00 PM	yes	2125551212	2125551234	Mom	Ewan@email.com
3
4	Concat	Teacher	Venue	DAY	TIME	Attending	PHONE NUMBER	secondary contact	Emergency contact	EMAIL ADDRESS
5	EwanSwimming Pool 1Thursday0.75yes	Ewan	Swimming Pool 1	Thursday	6:00 PM	yes	2125551212	2125551234	Mom	Ewan@email.com
Sheet1

Cell Formulas
Range	Formula
A2	=B2&C2&D2&E2&F2
A5	=B5&C5&D5&E5&F5
G2	=VLOOKUP($A2,$A$5:$J$5,COLUMN(),FALSE)
H2	=VLOOKUP($A2,$A$5:$J$5,COLUMN(),FALSE)
I2	=VLOOKUP($A2,$A$5:$J$5,COLUMN(),FALSE)
J2	=VLOOKUP($A2,$A$5:$J$5,COLUMN(),FALSE)

HTH,

 

[bruderbell]

Are you familiar with the Advanced Filter feature? Filter by using advanced criteria - Excel

Seems like it fits the bill here.

 

[Ewan11]

Hi guy you are awesome, I used a mixture of the concat cell and advanced filter in the end. Amazing thanks guys. appreciated