I guess the two identifers # in both sheets



"JLatham" wrote:

I agree, it sounds like a VLOOKUP() will work, I'm just a bit confused on
what to use for matching and what columns from where should be returned.

"CmK" wrote:


Hi

I think you need to use the Vlookup function
make sure the #'s in sheet2 is sorted asc
If you have trouble figuring out the Vlookup function let me know i will
show you how

thanks





"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