Lookup function, urgent question

[RaymondR32]

Hi, I am busy for some time to get the following result; I have two sheets, one is for example with names and email adresses, the other one is with the same names but without emailadresses. How can I create a column where i can put the correct email adresses in the same row as the name which is corresponding with the emailadress in the second sheet. For example sheet 1;
name email
justaname justaname@some.com

The second sheet is the same but in the second column there is no emailadress, the data is in sheet one, how can i match with the correct names and put the emailadr in ?

Thanks very much in advance, Raymond

 

[Juan Pablo González]

Have a look at the VLOOKUP worksheet function.

 

[RaymondR32]

Hi,

I tried already but it comes up with the wrong data, probably I did something wrong but the question is what ? Thanks anyway for your reply.

 

[Juan Pablo González]

The odds are that you're not using FALSE as the 4th (Optional) argument of VLOOKUP.

The formula should look like

=VLOOKUP(A2,Sheet2!Rangeofmails,2,FALSE)

or

=VLOOKUP(A2,Sheet2!Rangeofmails,2,0)

 

[Aladin Akyurek]

On 2002-02-26 07:53, RaymondR32 wrote:
Hi,

I tried already but it comes up with the wrong data, probably I did something wrong but the question is what ? Thanks anyway for your reply.

What formula did you try?

 

[Aladin Akyurek]

On 2002-02-26 07:53, RaymondR32 wrote:
Hi,

I tried already but it comes up with the wrong data, probably I did something wrong but the question is what ? Thanks anyway for your reply.

What formula did you try?

 

[RaymondR32]

Hi,

I did the VLookup function, I need to try the second suggestion, thanks all for the help, i will let you know the result...

 

[RaymondR32]

The problem is solved, thanks all for help !

Raymond

 

[Aladin Akyurek]

On 2002-02-28 04:24, RaymondR32 wrote:
The problem is solved, thanks all for help !

Raymond

How did you solve it?