Pulling data from one worksheet and merging into another

[GiniB]

Hi,

I have a question which, so far, the other threads haven't been able to assist me with....I am an Excel novice.

I have two work sheets (I'll call them 1 and 2) both contain different information about the same records; 14625 of them on 1 and 14687 on the other; each record is identified by a unique code on sheet 1, corresponding to the ones on sheet 2 (although I realise there are more on 2). I need to pull information from three columns on sheet 1 to their corresponding codes on sheet 2.

Initially I thought this would work with VLookup; but this seems to only work with one record at a time......but either way after following all the tutorials I still can't get it to work.

Has anyone any ideas that will help me?

Thanks in advance.

Gini

 

[Andrew Poulsom]

VLOOKUP should work. What do you mean by "this seems to only work with one record at a time"? Did you see this tutorial?

http://www.contextures.com/xlFunctions02.html