Use VLOOKUP
e.g
to get phone #Code:=VLOOKUP(A4,'Sheet2'!A:D,2,0)
to get address 1Code:=VLOOKUP(A4,'Sheet2'!A:D,3,0)
to get address 2Code:=VLOOKUP(A4,'Sheet2'!A:D,4,0)
where A4 contains the typed person's name, and Sheet2, columns A: D contain the database to look up.
Bookmarks