Dependent Drop Down List - 2 Columns

[NEW_2VBA]

Hello! I see a lot of examples online about creating dependent drop down lists but none seem to fit my current data setup.

The data setup is similar to the following: (sheet name = "List") (data below starts with Row 1)

ColumnA-Test	ColumnB-Type
TEST-A	Math
TEST-B	Science
TEST-C	Philosophy
TEST-C	Humanities
TEST-D	Art
TEST-E	History1
TEST-E	History2
TEST-F	Computer Science

I need to add a dependent drop down list on a separate sheet in column B, cell B2 (sheet name = "Report"). (data below starts with Row 1)
The dependent list in B2 should should display options from the list above ("List" worksheet) based on the selection in A2.

Column A - Select Test	Column B -Lookup Type [dependent drop down list]
(If I select "TEST-C" from drop down list here...)	(...I should see only two options on the drop down list here)

I think that I can use an OFFSET/Match formula in the Data Validation Source field, but I can't quite figure out to setup the formula. Thanks in advance!

 

[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’)

 

[NEW_2VBA]

Disregard! I found a solution for vertical layout! ?

 

[NEW_2VBA]

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’)

Will do! Appreciate the feedback!