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.

Search Criteria
Teacher	Venue	DAY	TIME	Attending
Ewan	Swimming Pool 1	Thursday	6:00 PM	yes

<tbody>
</tbody>

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

Teacher

Venue

DAY

TIME

Attending

PHONE NUMBER

secondary contact

Emergency contact

EMAIL ADDRESS

DOB

Age

Days until Birthday

FIRST NAME

SURNAME

<tbody>
</tbody>

 

[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