You need VLOOKUP. Check it out in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"smckay" wrote in
message ...

Hi I am new to using Excel more interactively. I am able to create a
drop down box so a user can choose a day of the week for example.

But I want to be able to populate other cells in the column depending
on the choice from the drop down list.

e.g. choose Tuesday from a list of days of the week in A2 and have B2,
C2 etc filled with related data.

Is this at all possible?

Thank you in advance.


--
smckay
------------------------------------------------------------------------
smckay's Profile:
http://www.excelforum.com/member.php...o&userid=35828
View this thread: http://www.excelforum.com/showthread...hreadid=556081