Hello, I have included an image of what I would like to accomplish. Thank you!
M msmonicadoll New member Joined Jul 11, 2013 Messages 1 Reaction score 0 Points 0 Jul 11, 2013 #1 Hello, 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 1 Points 0 Location Mississauga, Canada Excel Version(s) Excel 2016 Jul 11, 2013 #2 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.
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.