Prev: total point
Next: Dynamic Table Problem
From: JLatham on 4 Apr 2010 01:31
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.






"JLH" wrote:

> Hello,
> Most of you will find this way too EZ...but I am new to this...please help!
> I have a list of names on one spreadsheet and three times as many addresses
> and names on the other one. How can I use vlookup to match the names on my
> first worksheet and populate only the addresses I need?
> --
> JLH
 | 
Pages: 1
Prev: total point
Next: Dynamic Table Problem