Find matching value in 2 sheets and add value from row above found value to dropdown list without duplicating.

[Mike Neal]

I am trying to use the values in Column A on Sheet1 and find the matching values in Row 2 on Sheet2. Then add the values from the cells in Row 1 in Sheet2 of the column where the matching values were found to a combobox list without duplicating any values in the list. I can find examples to search for matches but nothing that uses an offset and adds them to a list. Any help would be appreciated. Thank you.

 

[Dave87]

Can you post some sample data

 

[Mike Neal]

ID Number	R300	R400	R501	R305	R303	R305
Location	REVLIS 3	REVLIS 4	REVLIS 2	REVLIS 3	AKROCHEM	STOW
Serial Number	3333	3333	3333	3333	44444	eeee
Model	44343	44343	44343	44343	33333	333
Manufacturer	dfgsfg	dfgsfg	dfgsfg	dfgsfg	ggggg	gggg
Year Built	3333	3333	3333	3333	666	wrwrw
Description	fdgsdfg	fdgsdfg	fdgsdfg	fdgsdfg	afaffafs	werwwr
Comments	sdfgsdfg	sdfgsdfg	sdfgsdfg	sdfgsdfg	asff	werwrwr
Date Entered	6/18/20	7/1/20	7/1/20	7/1/20	7/1/20	7/1/20
Task1	T106	T105	T202	T202	T107	T106
Task 2	T101	T106	T204	T106	T105	T101
Task 3	T202	T107	T106		T202	T105
Task 4	T203	T432	T107			T105
Task 5	T204	T202				T101
Task 6	T107
Task 7
Task 8
Task 9
Task 10

 

[Mike Neal]

This is Sheet1 some of the values are just typed in letters and numbers so I can see if my other macros are working.

 

[Mike Neal]

This is Sheet1 some of the values are just typed in letters and numbers so I can see if my other macros are working.

Actually that was Sheet2

 

[Mike Neal]

This is Sheet1

Equip ID	Task ID
R303	T202
R303	T105
R400	T202
R400	T106
R400	T105
R501	T101
R305	T432
R400	T107
R400	T204

 

[Mike Neal]

As you can see from my sheets for example: R303 is on sheet1 and sheet2. I would like my macro to take the R303 from sheet1 look it up on sheet2 and add the location "AKROCHEM" to my combobox drop down. I would like to do this for all Equip IDs on sheet1 and not have any duplicates in the drop down. There are 3 comboboxes on my userform. The first is the Location, the second is the Equip ID and the third is the Task ID. Sheet 1 is all the Equip IDs and Task IDs that are due. I am hoping to select a location and have only the Equip IDs from that location show up in the Equip ID drop down "These Equip IDs all have Tasks Due to be performed". The Task ID drop down will have all the tasks from sheet1 that are paired with the Equip ID that is selected.

Right now I have all the locations added to the list when the userform is initialized. I would rather have only the locations show that have an associated Equipment ID on the sheet1. I hope this makes sense.

Thanks for the help.