I need to create a formula that returns a value based on the value of another
column. If i enter the name in sheet 2 i need the location and position
column to auto fill with correct info.
Sheet 1 will be my data base.
Sheet 1

Name Location Position
Joe Miami Tech
Mary New York Manager
Frank LA Client

Sheet 2

Name :
Location :
Position:

=VLOOKUP(B2,Sheet1!A:C,2,False)

and

=VLOOKUP(B2,Sheet1!A:C,3,False)

--
__________________________________
HTH

Bob

"Majic" wrote in message
...
I need to create a formula that returns a value based on the value of
another
column. If i enter the name in sheet 2 i need the location and position
column to auto fill with correct info.
Sheet 1 will be my data base.
Sheet 1

Name Location Position
Joe Miami Tech
Mary New York Manager
Frank LA Client

Sheet 2

Name :
Location :
Position:

Sheet1 A2:A4 = names
Sheet1 B2:B4 = locations
Sheet1 C2:C4 = positions

Sheet2:

A1 = name = Mary

Enter this formula in A2 and copy down to A3:

=VLOOKUP(A$1,Sheet1!A$2:C$4,ROWS(A$2:A2)+1,0)

--
Biff
Microsoft Excel MVP


"Majic" wrote in message
...
I need to create a formula that returns a value based on the value of
another
column. If i enter the name in sheet 2 i need the location and position
column to auto fill with correct info.
Sheet 1 will be my data base.
Sheet 1

Name Location Position
Joe Miami Tech
Mary New York Manager
Frank LA Client

Sheet 2

Name :
Location :
Position: