Populating cells

S

S. Heff

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.
 
S

S. Heff

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