Drop down list + other data

[Iywilson001]

I am trying to get the ID# on the vacancy sheet to pullOver to the id# column on the onboarding sheet as a dropdown IF column N of the vacancy sheet has ACTIVE.
I also want the corresponding data on B-E of the vacancy tracker to pull over to the onboarding tracker.

 

[Eric W]

Welcome to the MrExcel forum!

If your Onboarding sheet looks like:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Onboarding	Vacancy
2
3		ID #	LOC	DIV	SECTION	POSITION	STATUS	HR POC	OPEN	CLOSE	SELECTEE	COMMENTS	activity
4		12345	ohio	carport	frontend	cashier	Selection Made	Tera Cobb	1/1/2024	1/11/2024	Ashly Jones		active
5		999999	Texas	Washer	cleaning	cleaner	Selection Made	Angel goblet					inactive
6		3456123	Canada	Marketing	Carwash	Signer	Selection Made	Carol Thomas					active
7
Onboarding

Then you can use these formulas to achieve your request:

Book1
	A	B	C	D	E	F	G	H	I
1	Onboarding	Vacancy							Work
2									12345
3		LOC	DIV	SECTION	POSITION	ID #			3456123
4		ohio	carport	frontend	cashier	12345
5
6
7
Vacancy

Cell Formulas
Range	Formula
I2:I3	I2	=FILTER(Onboarding!B4:B100,Onboarding!M4:M100="active")
B4:E4	B4	=IF(F4<>"",INDEX(Onboarding!$B$4:$M$100,MATCH(F4,Onboarding!$B$4:$B$100,0),{2,3,4,5}),"")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
F4:F6	List	=$I$2#

Notice that you'll need a work column somewhere to filter the list of IDs that are active. I use the I2 formula to do that. This is used by the Data Validation in column F. Then the formula in B4 will look up the rest of the desired data. Let me know if this is what you're looking for.

 

[Iywilson001]

Thank you so much. This worked perfectly!!

 

[Eric W]

Happy to help!