Excel List functions and linking cells
 

I am creating a document register with drop down lists for Document Revision
No's. I need to use a function if there is one whereby for each revision I
can type a note in the cell and also the date in adjacent cells that is
linked to the drop down lists that can be recalled at any time.

For example, For revision 01, a certain note I wrote will be shown and then
if I drop down to revision 2, a different note and date is shown. Is there a
way I can do this so that overtime I can recall any of the drop down list
values and find the note I wrote next to it??

I already know how to create a list but I need to know how to link that list
with the adjacent cells I guess..

Any suggestions will be gratefully received.
Thanks

Excel List functions and linking cells
 

"Andys Mitten" wrote in message
...
I am creating a document register with drop down lists for Document
Revision
No's. I need to use a function if there is one whereby for each revision
I
can type a note in the cell and also the date in adjacent cells that is
linked to the drop down lists that can be recalled at any time.

For example, For revision 01, a certain note I wrote will be shown and
then
if I drop down to revision 2, a different note and date is shown. Is
there a
way I can do this so that overtime I can recall any of the drop down list
values and find the note I wrote next to it??

I already know how to create a list but I need to know how to link that
list
with the adjacent cells I guess..

Any suggestions will be gratefully received.
Thanks

I'm a bit confused by what you ask, but I think you need to use VLOOKUP.
This would take the value from a cell, look it up in the first column of
your list and return the corresponding data from the second (or subsequent)
column of the list.

To get you started, suppose the list is in A1:C10 (notes in column B and
dates in column C), and the cell with the revision number is E20.

In (say) F20 this formula
=VLOOKUP(E20,A1:C10,2,0)
will return the corresponding note, and in (say) G20 this one
=VLOOKUP(E20,A1:B10,3,0)
will return the corresponding date.

Excel List functions and linking cells
 

Stephen

Thats brilliant. Seemed to do exactly what I needed it to.

Thanks alot




"Stephen" wrote:

"Andys Mitten" wrote in message
...
I am creating a document register with drop down lists for Document
Revision
No's. I need to use a function if there is one whereby for each revision
I
can type a note in the cell and also the date in adjacent cells that is
linked to the drop down lists that can be recalled at any time.

For example, For revision 01, a certain note I wrote will be shown and
then
if I drop down to revision 2, a different note and date is shown. Is
there a
way I can do this so that overtime I can recall any of the drop down list
values and find the note I wrote next to it??

I already know how to create a list but I need to know how to link that
list
with the adjacent cells I guess..

Any suggestions will be gratefully received.
Thanks

I'm a bit confused by what you ask, but I think you need to use VLOOKUP.
This would take the value from a cell, look it up in the first column of
your list and return the corresponding data from the second (or subsequent)
column of the list.

To get you started, suppose the list is in A1:C10 (notes in column B and
dates in column C), and the cell with the revision number is E20.

In (say) F20 this formula
=VLOOKUP(E20,A1:C10,2,0)
will return the corresponding note, and in (say) G20 this one
=VLOOKUP(E20,A1:B10,3,0)
will return the corresponding date.