align data

  • Thread starter Thread starter gonzo
  • Start date Start date
G

gonzo

I have two worksheets, each has a two columns with 5,000 values ( towns and
zip codes).

i want to merge both worksheets side by side with the matching data aligned
in a 4 column worksheet.

worksheet 1
Melbourne,3000

worksheet 2
3000, Victoria

merged worksheet
Melbourne,3000,3000,Victoria.

any suggestions ?

thanks in advance.
 
Next to 3000 on sheet 1 enter:

=Vlookup ([cell that has 3000 on sheet1],[range of the
5000 cells on sheet 2 - both columns], 1, false)

Repeat this formula for column 4, but change the "1,
false" to "2, false"

you should get:

Column A Column B Column C Column D
Melbourne 3000 3000 Victoria
 
Back
Top