linked data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
Thanks so much, a big help. Is there a reference for expressions (like !, as
used in !A:C) that is easily accessible? Thanks again,
 
mjstizzle said:
Thanks so much, a big help.
Click to expand...

You're welcome !
Is there a reference for expressions (like !, as
used in !A:C) that is easily accessible?
Click to expand...

"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"
 
g"mjstizzle said:
Thanks so much, a big help.
Click to expand...

You're welcome !
Is there a reference for expressions (like !, as
used in !A:C) that is easily accessible?
Click to expand...

"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"
 
Back
Top