I'm running Excel 2013 and I have two spreadsheets open. The first, sheet1, has two columns and 7k rows the columns are:
A B ID Description 58749651 a bunch of text
The second, sheet2, has 24 columns and 26,000 rows. Column "A" is the same as in the first sheet - title "ID" and the values are numbers. There is no "description" column in sheet2 - which is my question.
How can I create a description column on sheet 2 (it would be column "U") and populate it with the description from sheet 1 where the ID values match?
There's probably 1500 or so ID's on sheet1 that are also on sheet2 and I need to merge just the description from sheet1 into the appropriate row on sheet2.
Anyone have any ideas on how to do this or where I can find the information? Thanks! Rob