Excel question

[Robbob]

is there a forumla that allows you to have fields populated when something is selected from a list?

ie have the 12 months in the list and when a specific month is selected specific fields populate from numbers on a different sheet.

Just wondering how to start off the forumla and then I can take it from there.

Any help or advice would be very much appreciated!

[Robbob]

I'm guessing with as many views as I have had on this that it isn't possible or isn't easy. Doh.

[Robbob]

the question I got is how do you do that formula for each month because as far as I know you can only enter 7 functions. Is there a way to do the search without each month being a search? I also don't need a range of data I just need one cell from another list.

I was hoping it would be as simple as if this cell says this (pulled froma list) then this cell equals that cell in that list.

Crazy excel

[Bring_Back_Shantz]

I'm not 100% sure what you're asking for, but it sounds like what you want to do will either require macros, or using a dropdown box with a linked cell.

[Teh_Bandwagoner]

Yeah hard to say without seeing. Sounds like you're asking about how to setup pivot tables IMO.

Pivot tables allow you to select a variable from a dropdown menu in a cell, which can then repopulate a table with any other set of variables you choose. It's basically a dynamic excel table.

PM me if this is what you need and I can probably step you through that in more detail.

Edit: OR Microsoft has their own tutorial on pivot tables here! See if that's what you need.
http://office.microsoft.com/training...RC010136191033

[Nage Waza]

You can do what you want, but have to make sure the list your are looking at is in alphabetical order...