merge unlike & like data in excel

V

Valerie

I'm merging data from two separate and different workbooks. I know I can
make them look similar to start with by adding columns to each of them and
rearranging the columns. The problem I have is that I not only need to get
the information in one spreadsheet but I also need to get the information
merged in rows. For example, I have a column of policy numbers in both
spreadsheets but only one of the spreadsheets contain the address for the
policy number. I need to get the address in the same row as the policy
number. After I get this set up, I'll be using the information to do a
mailing by mail merging into Microsoft Word. I know how to do that part.

Any suggestions?
Thanks,
Valerie
 
P

paul

you could use a vlookup on the policy numbers from sheet 1 on sheet 2 and
look in the column that contain the adresses and return them to sheet1
example say sheet 1 has policy numbers in a1 down to a100
sheet 2 has the same(or similar) list of policy numbers in column a and
addresses in col b
in b1 on sheet 1 type =vlookup(A1,Sheet2!$A$1:$B$100,2,false),and copy
down.If the lookup finds the matching policy number on sheet 2,it will return
the address from the corresponding row in sheet 2,if there isnt a match it
will show #NA.You can suppres that and show whatever you want instead by
typing
=if(isna(vlookup(A1,Sheet2!$A$1:$B$100,2,false)),"no
match",vlookup(A1,$A$1:$B$100,2,false))
 
Top