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: