Dynamic Drop Down List (Microsoft Excel 2019)

[Panama1182]

Need help creating a dynamic drop down list in Excel. My current option is very manual and requires me to go to another tab and filter data by XYZ Code and then copy and paste all possible XYZ Descriptions horizontally in the desired sheet. Problem is there is about 1000 records (rows) and in some cases there are 100 different possible XYZ Descriptions.

 

[Panama1182]

Any thoughts?

 

[Tom.Jones]

Look here: Excel Data Validation Topics on Contextures.

 

[Panama1182]

Thank you Tom.Jones. I was able to find a solution and used the offset formula as follows:

=OFFSET($K$3,MATCH($F4,$F$4:$F$4929,0),0,COUNTIF($F$4:$F$4929,$F4),1)