Populating cells

[Guest]

I am creating a worksheet. In it, one cell has a drop-down to select 1 of 9
values.
Once one of these nine values is selected, I want other cells to
auto-populate from other information within the worksheet.

I tried the "IF" function but could only nest seven functions within that
function. Is there some other function I can use to have these other cells
auto-populate based on the selection of that initial cell?

Any help is greatly appreciated.

 

[davesexcel]

If you have a sheet that has data in say column A and column B and
column C
you could use a vlookup function

=VLOOKUP(A1,Sheet2!A32:C34,2,FALSE)

maybe this site could hgelp you, I am sure it has been reffered to a
thousand times

http://www.contextures.com/xlFunctions02.html

 

[Guest]

That worked like a charm (once I realized my reference cells couldn't be
merged cells)! Mission accomplished. Thanks for your help.