+ Reply to Thread
Results 1 to 5 of 5

Vlookup in multiple sheets returns N/A

  1. #1
    Registered User
    Join Date
    06-22-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013
    Posts
    6

    Vlookup in multiple sheets returns N/A

    First off, let me thank all of the Excel masters out there that have helped countless people in this forum. Your assistance is greatly appreciated!

    I am trying to match up a cost with a product name. I have a list of products that I have sold, and want to have column that populates the item cost, which is located in another sheet.

    I cannot figure out why this is not working. I am thinking it has something to do with the actual product names?

    Thanks for having a look. All the best.
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Vlookup in multiple sheets returns N/A

    Quote Originally Posted by hanhj View Post
    I am thinking it has something to do with the actual product names?
    You're right. the Cost sheet data has trailing spaces. Delete them and you'll get a match.

    I'll do it and reattach for you
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Vlookup in multiple sheets returns N/A

    Here you go. It also had a few trailing space in your other sheet too.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-22-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Vlookup in multiple sheets returns N/A

    Amazing! I didn't even see that. Many thanks!

  5. #5
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Vlookup in multiple sheets returns N/A

    Great. Glad its sorted out for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vlookup returns 1/0/1900 search two sheets
    By cipherblue in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2015, 03:20 PM
  2. Vlookup - multiple returns
    By surfsup00 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2014, 12:12 PM
  3. VLOOKUP returns error if value is not in all sheets?
    By MJ10 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2013, 06:43 PM
  4. Replies: 1
    Last Post: 03-14-2013, 12:21 PM
  5. Vlookup with multiple returns
    By Erik Thomas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2012, 02:30 AM
  6. Vlookup with multiple returns
    By SITKAN in forum Excel General
    Replies: 1
    Last Post: 01-25-2010, 03:11 PM
  7. [SOLVED] Vlookup Multiple Returns #REF
    By Ben in forum Excel General
    Replies: 3
    Last Post: 06-28-2005, 04:05 PM

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