Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of Excel 2003 Functions | Excel Worksheet Functions | |||
Excel 2003 list of new functions in this version | Excel Worksheet Functions | |||
linking items from drop down list in excel | Excel Worksheet Functions | |||
How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
Using Excel link (hyper?) and list functions | Excel Worksheet Functions |