Can't find the right formula!

  • Thread starter Thread starter MSleasman
  • Start date Start date
M

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