Excel Row Dropdown

[paul_etl_developer]

Hi Guys,

I need some help, I'm trying to create a dropdown for Dropdown Column using values from Column A and Column B.
I already know how to create a dropdown on my first row but I have 1000+ rows. Does this mean that I have to do it one by one? or is there a way to automatically create a dropdown with the corresponding value from Column A and Column B?

Column A Column B Dropdown Column
Value A1 Value B1 Dropdown(Value A1, Value B1)
Value A2 Value B2 Dropdown(Value A2, Value B2)

Thanks

[vlady]

Good day Kabayan.

go to Data Validation
Under the Allow box Select List
Under the Source select the range you'l come up something like this =$A$3:$B$3
then delete the Dollar sign before the numbers ->=$A3:$B3
then hit ok.
you can use the fill handle to drag down the validation list now.

regards,
Vladimir

[paul_etl_developer]

Good Day Kabayan!

This is a big help! Thank you so much for your detailed solution.

[vlady]

Your Welcome.