Auto Fill, Excel 2010

msmonicadoll

New member
Joined
Jul 11, 2013
Messages
1
Reaction score
0
Points
0
How to Auto Fill_Page_1.jpgHello, I have included an image of what I would like to accomplish. Thank you!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Use VLOOKUP

e.g

Code:
=VLOOKUP(A4,'Sheet2'!A:D,2,0)
to get phone #

Code:
=VLOOKUP(A4,'Sheet2'!A:D,3,0)
to get address 1

Code:
=VLOOKUP(A4,'Sheet2'!A:D,4,0)
to get address 2

where A4 contains the typed person's name, and Sheet2, columns A: D contain the database to look up.
 
Top