Excel is making my head hurt

AtomBomb

I have 2 spreadsheets. One has 800 entries with 3 columns (First Name, Last Name, Email). The other has 6,000 entries with 4 columns (First Name, Last Name, Email, Account #). I need to somehow get the account numbers on to the smaller spreadsheet. It seems like I should be able to do it, but I'm blanking out.

The smaller spreadsheet is a subset of the larger one, so everyone that is on the smaller one is on the larger one.

Septus

I don't get it, the 800 names on the smaller sheet also exist on the larger sheet, but with account numbers as well? Because then the larger sheet already has everything you need from the smaller sheet.

chamberlain

vlookup will do exactly what you are trying to do.

http://office.microsoft.com/en-us/excel/HP052093351033.aspx

AtomBomb

Thanks chamberlain, vlookup did it! I couldn't get it to span sheets, but I just pasted the small list to the right of the big list.

Septus, the larger sheet did have everything I need, but it also had a bunch of stuff I didn't need. It didn't have the 800 marked in any way, they were randomly throughout.

Spherick

vlookup should go across sheets. I always rename the data field that im fetching through excel and just use that.

Pheezer

Yeah, VLOOKUP definitely does span sheets and workbooks.

Type the first part: =VLOOKUP(A2,
then use the mouse to select the other worksheet, and highlight the columns in question. The entire columns.

Then hit a comma and finish the formula. Super easy.