populating multiple cells from a dropdown list

[rholdren]

I just might not be looking in the right area. I've been searching for a day an a half now and I seem to be stuck searching (Einstein's Crazy Statement inserted her)

Let's say I have a dropdown box in cell A5 with a column header of month. B5 is season C5 is Holiday and D5 is temperature
The Data for Season, Holiday, and Temperature is located in Range A100.C100 The month list is located on another sheet

All I am trying to get this to do is when February is selected in A5 that B5's value is = to A100 C5's Value is = to B100 and D5's Value is equal to C100

I have tried a variety of searches and I’m not sure I am searching with the correct phrases. This is probably a simple thing and I’m making it harder than I need to (like usual)
Any help would be greatly appreciated.
Thanks

 

[wrightyrx7]

I dont think you have explained this correctly because from what i am reading it would just be

B5 = "=IF(A5="February",A100,"")"
C5 = "=IF(A5="February",B100,"")"
D5 = "=IF(A5="February",C100,"")"

You may need to explain what happens when another value is selected. Im assuming you have 12 months is that list, and doing the above for each month might be a bit long winded. But if you give us some more details we might be able to help a bit better.

 

[My Aswer Is This]

I did not understand this:

The Data for Season, Holiday, and Temperature is located in Range A100.C100 ​

The month list is located on another sheet

​

Please never say another sheet.

We need the sheet name​

​

 

[rholdren]

It's okay I just figured it out. Thanks