Linking Cells
 

Is it possible to have a cell linked to multiple cells in a different column.
I want A1 to have a dropdown so I can select my dated title of my
information on A2. Then I would like for B2-B4 to display when I select A2.
And when I select A3, B5-B6 will display informaton.

A1-Called DATE with a dropdown
A2-022108_Information
B2-B4- Line items that I would like to display when I select A2
A3-022208_Information
B5-B6 Line items that I would like to display when I select A3

Is this possible?
Do you have a website with some examples?

Thanks for your help,..

Linking Cells
 

You could use VLOOKUP to return the data to B2:B4 and B5:B6

See Debra Dalgleish's site for info on VLOOKUP function to pull data based on
the selection from the DV list.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 11:41:02 -0800, Mac wrote:

Is it possible to have a cell linked to multiple cells in a different column.
I want A1 to have a dropdown so I can select my dated title of my
information on A2. Then I would like for B2-B4 to display when I select A2.
And when I select A3, B5-B6 will display informaton.

A1-Called DATE with a dropdown
A2-022108_Information
B2-B4- Line items that I would like to display when I select A2
A3-022208_Information
B5-B6 Line items that I would like to display when I select A3

Is this possible?
Do you have a website with some examples?

Thanks for your help,..