Originally Posted by
JBeaucaire
Assuming sheet2 is a "database" where the values in column A have additional information listed in columns B:F (phone numbers, addresses, etc.) then on SHeet1 you would use a VLOOKUP formula to bring over the information.
Assuming on sheet1 A2 you have selected a name that matches a row in column A of sheet2, you could use:
B2: =VLOOKUP(A2, Sheet2!$A:$F, 2, 0)
C2: =VLOOKUP(A2, Sheet2!$A:$F, 3, 0)
D2: =VLOOKUP(A2, Sheet2!$A:$F, 4, 0)
E2: =VLOOKUP(A2, Sheet2!$A:$F, 5, 0)
F2: =VLOOKUP(A2, Sheet2!$A:$F, 6, 0)
Read the help files in Excel on VLOOKUP.
Bookmarks