A lot depends on how you have that second sheet set up.
To work, first the names on the two sheets must match up exactly with
regards to spelling and punctuation.
On the second sheet, the names must be in the leftmost column of a 'table'
that the VLOOKUP() will reference.
For example's sake, I'm going to assume your second table looks something
like this:
A B C D E
1 name street city state zip code
and we will say that the name of that 2nd sheet is Sheet2, and that the
table goes down to row 300
on the first sheet, your names are in column A also (don't have to be), and
you want to return all of the related address for each entry, and they begin
on row 2.
In b2 enter formula =VLOOKUP(A2,'Sheet2'!$A$1:$E$300,2,False)
in c2 enter formula =VLOOKUP(A2,'Sheet2'!$A$1:$E$300,3,False)
in d2 enter formula =VLOOKUP(A2,'Sheet2'!$A$1:$E$300,4,False)
and finally,
in e2 enter formula =VLOOKUP(A2,'Sheet2'!$A$1:$E$300,5,False)
You can now fill those formulas down to the end of the list of names on the
first sheet and you'll get the information from the second one. If a name on
the first sheet (one with the formulas) does not match any name on the second
sheet you will get #N/A as the result. You could prevent that by modifying
the formulas like this (one for B2 shown)
=IF(ISNA(VLOOKUP(A2,'Sheet2'!$A$1:$E$300,2,False)),"No
Match",VLOOKUP(A2,'Sheet2'!$A$1:$E$300,2,False))
Remember that the formula is entered all in one line, not split like the
system here probably has done to it.
