OK, let's try this.

There is data in column A, C and D. I want a formula to place into a cell
in column B.

If the value in column A (call it "x") matches any value in Column C (eg.
range $c$2:$c$1300), then insert value from column D into cell in column B.

For example, we're putting the formula in B3. In A3 the value is 222. The
formula in B3 would look for any value of 222 in C2:C1300 and return the
value to the immediate right of the match. So if the match is found in C888
and the value in D888 is 911, then B3 should return 911. If there is no
value in that position, it should just return a blank.

There will be only one match maximum between values in Column A and C. some
values in D will be blank.



"JLatham" wrote:

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