Lookup function, urgent question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Lookup function, urgent question

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have a look at the VLOOKUP worksheet function.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,779
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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?

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,779
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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?

  7. #7
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The problem is solved, thanks all for help !

    Raymond

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,779
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

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

    Raymond
    How did you solve it?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com