Drop-Lists and related data

[patxlb]

I am creating a worksheet with a drop list & need to have various data appear in select rows passed on the choice taken on the list.

For example, if the second item in the dropdown list is chosen, then row 27 and 29 need to contain specific data. The row numbers will be the same regardless of the choice made, but the data within these rows will be different.

Thanks for your assistance.

[starguy]

I am creating a worksheet with a drop list & need to have various data appear in select rows passed on the choice taken on the list.

For example, if the second item in the dropdown list is chosen, then row 27 and 29 need to contain specific data. The row numbers will be the same regardless of the choice made, but the data within these rows will be different.

Thanks for your assistance.

you need to attach here a sample file in zip format.

[patxlb]

The zipped file is attached. What I want to do:

Whatever is chosen in the drop list in C16 (sheet 1) would then enter data in B27 & B29. The corresponding data is in sheet 2.

I hope I've explained this clearly. Thanks for your help

[redstang423]

In cell B27, use the formula =VLOOKUP(C16,'Sheet 2'!A2:C4,2,FALSE). C16 is the lookup value, A2:C4 is the range of data you are looking at and finding a match to C16in the first column, and 2 is the number of the column in the data range where you want to pull the value from.

[BigBas]

Hopefully, I have correctly understood your request. If so, enterring this formula into both B27, and B29 will solve your problem.

=IF(C16<>"",C16,"")

Let me know if that works.

[patxlb]

Thank you so much. The VLOOKUP formula works perfectly!