Linking Cells in Workbooks

[DW Organizer]

Hello,

I'm trying to link two worksheets together. I have a master file that
contains all the information for participants in our youth organization. I
have to track their uniforms which are given a specific number. How would I
link the master that whenever I type in a certain uniform number it will fill
in the current participants name...
Jane Doe 04-S-07 01-01-01 etc.. Wt. Class


Second Worksheet would only show
04-S-07 (I'd like Jane Doe here) (wght Class)
The name and wgt will change year to year..

I know I can use access (not too familiar, but everyone else in the
organization uses excel.) Thanks in advance....

 

[JE McGimpsey]

Hello,

I'm trying to link two worksheets together. I have a master file that
contains all the information for participants in our youth organization. I
have to track their uniforms which are given a specific number. How would I
link the master that whenever I type in a certain uniform number it will fill
in the current participants name...
Jane Doe 04-S-07 01-01-01 etc.. Wt. Class


Second Worksheet would only show
04-S-07 (I'd like Jane Doe here) (wght Class)
The name and wgt will change year to year..

I know I can use access (not too familiar, but everyone else in the
organization uses excel.) Thanks in advance....

Well, you can't use access on the Mac, except using Bootcamp/Parallels,
etc. (you've posted in a newsgroup for Mac XL, so I assume you're using
a Mac, though for this purpose, it doesn't really matter.)


One way:

On your second worksheet:

A2: 04-S-07
B2: =INDEX(Sheet1!A:A, MATCH(A2, Sheet1!B:B, FALSE))
C2: =INDEX(Sheet1!C:C, MATCH(A2, Sheet1!B:B, FALSE))