Excel 2007 Compare / Copy values from 2 worksheets

[senpai]

There has to be a simple way to do this.

worksheet 1:
It has two columns with over 1000 rows in which the value in A1 will match with B1, A2 to B2, etc

worksheet 2:
It has one column with mostly the same information as worksheet 1's column B


I want to look up information in worksheet 1 column A, and copy it to its corresponding B value in worksheet 2.


If you must know why, it's because worksheet 2 has the absolute correct values of column B, whereas worksheet 1 is a compilation of various sheets.

 

[Qwertyman]

vlookup, very easy actually.

1) sort worksheet 1 column A and expand the selection.

2) then goto worksheet 2, click the fx button and goto vlookup. Keep worksheet 1 open.

3) lookup value is A2 in worksheet 2, table array is A2 (not A1) to B2 then down to your last row in worksheet 1(generally make a box from a2 over to b2 all the way to the bottom, it should look like a giant rectangle of highlighted data with the column headings not selected) Column Index is the number 2 (second column) Range lookup is FALSE.

The fx function box will give you the formula result and you will know it is working when you finish the formula.

When done, just copy it from a column in worksheet 2 down to the bottom so A2 will turn to A3,A4,A5, etc.