+ Reply to Thread
Results 1 to 3 of 3

Need help in formula for vlookup of duplicate values :-)

  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Red face Need help in formula for vlookup of duplicate values :-)

    From few months, I have lost touch with excel formulas
    The below is my data related vlookup in excel sheet.
    The number is the main lookup value which appears in sheet1 and sheet3
    However, in sheet 3 number and name appears
    Please help me in updating the names in sheet 1 by doing vlookup for the values from sheet 3.

    I have attached an excel sheet Example.xlsx for clear understanding of the issue

    My vlookup formula =VLOOKUP(A2;Sheet3!A2:B30;2;0) did not help me in updating the names, as all the duplicate value numbers updated the names with #N/A values, please help me with a formula
    Attached Files Attached Files
    Last edited by vbvba; 05-13-2013 at 11:53 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Need help in formula for vlookup of duplicate values :-)

    you may want to add the $ to the range - so as you copy down the look up is not changing

    =VLOOKUP(A2;Sheet3!$A$2:$B$30;2;0)

    also if the value is not found and you do not want a #N/A error
    try this

    IFERROR(VLOOKUP(A2;Sheet3!$A$2:$B$30;2;0),"")

  3. #3
    Registered User
    Join Date
    06-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Talking Re: Need help in formula for vlookup of duplicate values :-)

    Thanks a lot for your help..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1