Data validation dropdown based on another cell value

[Anupam9]

Hello,
I am trying to add a dropdown list in cell F5 which should be based on selection of cell B5. I am attaching the sheet here, in sheet 2 i have added the data which should comeup as list in F5 by selecting each type. I have added formula in data validation as list however it is not taking bigger formulas due to space in data validation field. I am attaching file link here. Box
Please assist, thank you

 

[jorismoerings]

Hi,

Try this:

1. open data validation in Cell F5;
2. choose list
3. add this as the formula

   =INDEX(Sheet2!$A$2:$T$6,0,MATCH(Sheet1!$B$5,Sheet2!$A$1:$T$1,0))

 

[Anupam9]

Thank you Jo