Can I ask you to describe it in slightly different fashion? As usual, I'm
having trouble visualizing the whole thing.

Perhaps like this:
I wish to copy information from sheet 1, columns x, y, z. to sheet 2,
columns q, r, s when value in column A on sheet 2 matches column B on sheet 1.

or
I wish to copy information from sheet 1, columns x, y, z. to sheet 2,
columns q, r, s when value in column A or B on sheet 2 matches column B on
sheet 1.

"anand" wrote:

I don't know if there is a way to do this but if anyone can tell me, it would
save me days of work.

I have 2 sheets, one with many columns of numbers but one column with
identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns
of #'s (sheet 2, column b and c).

Column A and Column B both contain common identifier #'s (column B only has
1500 of 3000 total while Column A has all 3000).

What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s
matching positions (i.e. row) with the Sheet 1 identifier #'s.

Otherwise i will have to manually move data for 1300 cells from sheet 2 to
sheet one. Doable but tedious.

Any shortcuts?

Thanks

anand