Dynamic Dropdown using Data Validation list .

[jambar]

I have 3 columns of text data in Columns A , B and C . I have the text input in D1 ( which is from Column A) and text input in E1(which is from Column B ) . Now I want a dropdown list in F1 , which should be matching data for E1,F1. How to get this done ? Thanks for the help .

 

[Peter_SSs]

Done

Thanks.

Can someone suggest a solution without using VBA?

So, did my suggestion for Data Validation work for you?

 

[jambar]

Hi Peter, I am on Excel 2016 and I do not want to use VBA code ....any solution using aggregate, offset, array formula is what I look for please .

 

[Peter_SSs]

Hi Peter, I am on Excel 2016 and I do not want to use VBA code ....any solution using aggregate, offset, array formula is what I look for please .

Doesn’t post #9 meet all those conditions?