Can't find the right formula!

[MSleasman]

I am working on a file in which I am linking two worksheets. The firs
worksheet has a list of team numbers, names, etc. I want to make it s
that if I enter the team number in the second worksheet, i
automatically pulls the remaining information for that team into th
line.

The file is attached, and this is what I'm trying to do:

Worksheet 1:
Cell A1 (team): 1
Cell B1 (name): Joe Anderson
Cell C1 (handicap): 3
Cell D1 (partner): Bill Smith
Cell E1 (handicap): -2
Cell F1 (home club): Forest Springs Country Club

Worksheet 2:
If I enter the number "1" in Cell B3, I want it to pull the remainin
team information that corresponds to team 1 in worksheet one, to th
following cells in that row

Attachment filename: club.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64539

 

[igorek]

You may need to consider a series od vlookup formulas for
all the fields.
Or you can use 'cancatenate' function on the first sheet
and then only one 'vlookup' on the second

Good luck
Igor

 

[Domenic]

Hi,

Try the following...

1) Select cells C3 to G3 in Sheet2 (these cells should all b
highlighted)

2) Press =

3) Enter the following array formula, which must be entered usin
CONTROL+SHIFT+ENTER:

=VLOOKUP(B3,Sheet1!$A$2:$F$100,{2,3,4,5,6},0)

Adjust the range accordingly.

Hope this helps

 

[MSleasman]

The VLOOKUP worked perfectly! Thank you so much for your help!!!!!

~Melissa