=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: