Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linked data
Thanks in advance for the assistance.
In a pre-existing form with a drop-down box containing multiple text selections, I am trying to link the selection of that drop down box to auto-fill the rest of a form. (For example, when I select a name from a drop-down box, the associated phone number and address would automatically appear in their respective boxes on the form) |
#2
|
|||
|
|||
One way via VLOOKUP ..
Assume you have the reference table below in say, Sheet2, cols A to C Name Tel Add N1 T1 Add1 N2 T2 Add2 N3 T3 Add3 N4 T4 Add4 N5 T5 Add5 etc Suppose your form is in Sheet1, where A1 contains the DV to select the names: N1, N2, N3 ... To retrieve the associated Tel #, use: =VLOOKUP(A1,Sheet2!A:C,2,0) To retrieve the associated Address, use: =VLOOKUP(A1,Sheet2!A:C,3,0) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mjstizzle" wrote in message ... Thanks in advance for the assistance. In a pre-existing form with a drop-down box containing multiple text selections, I am trying to link the selection of that drop down box to auto-fill the rest of a form. (For example, when I select a name from a drop-down box, the associated phone number and address would automatically appear in their respective boxes on the form) |
#3
|
|||
|
|||
Thanks so much, a big help. Is there a reference for expressions (like !, as
used in !A:C) that is easily accessible? Thanks again, "Max" wrote: One way via VLOOKUP .. Assume you have the reference table below in say, Sheet2, cols A to C Name Tel Add N1 T1 Add1 N2 T2 Add2 N3 T3 Add3 N4 T4 Add4 N5 T5 Add5 etc Suppose your form is in Sheet1, where A1 contains the DV to select the names: N1, N2, N3 ... To retrieve the associated Tel #, use: =VLOOKUP(A1,Sheet2!A:C,2,0) To retrieve the associated Address, use: =VLOOKUP(A1,Sheet2!A:C,3,0) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mjstizzle" wrote in message ... Thanks in advance for the assistance. In a pre-existing form with a drop-down box containing multiple text selections, I am trying to link the selection of that drop down box to auto-fill the rest of a form. (For example, when I select a name from a drop-down box, the associated phone number and address would automatically appear in their respective boxes on the form) |
#4
|
|||
|
|||
"mjstizzle" wrote:
Thanks so much, a big help. You're welcome ! Is there a reference for expressions (like !, as used in !A:C) that is easily accessible? "Sheet2!A:C" is simply a range reference to the entire cols A to C in the sheet named as: Sheet2 Perhaps try Excel's Help on: "About cell and range references" -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#5
|
|||
|
|||
g"mjstizzle" wrote:
Thanks so much, a big help. You're welcome ! Is there a reference for expressions (like !, as used in !A:C) that is easily accessible? "Sheet2!A:C" is simply a range reference to the entire cols A to C in the sheet named as: Sheet2 Perhaps try Excel's Help on: "About cell and range references" -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |