+ Reply to Thread
Results 1 to 9 of 9

Help - How to match and return the value

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    SG
    MS-Off Ver
    2007
    Posts
    21

    Help - How to match and return the value

    As refer to below images reference.

    I am trying to find the value of the quantity value from Sheet 2 if it matches the fruit name to be input inside Sheet 1. Try using LOOKUP but it only return me the value 1 for everything as the name only appear there once.

    Example.jpg
    Last edited by reeNce; 08-05-2015 at 11:05 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Help - How to match and return the value

    try this in Sheet1 B1 copy down:

    =VLOOKUP(A2,Sheet2!$B$2:$C$4,2,0)
    If I've helped U pls click on d *Add Reputation

  3. #3
    Registered User
    Join Date
    08-05-2015
    Location
    SG
    MS-Off Ver
    2007
    Posts
    21

    Re: Help - How to match and return the value

    I tried the code, it work for B3 (orange) & B4 (Grape) but B2 (Apple) display N/A

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help - How to match and return the value

    Check for a leading or trailing space in both cells
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    08-05-2015
    Location
    SG
    MS-Off Ver
    2007
    Posts
    21

    Re: Help - How to match and return the value

    You're right man ! It work wonder right now, thank you for helping up.

  6. #6
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Help - How to match and return the value

    hmm strange..please refer to the attached file based on the scenario you provided above. You sure you don't have any spaces in the cells?
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Help - How to match and return the value

    ok glad you made it work.

    If you're satisfied with the answers please mark this thread as Solved and consider giving a rep to those who've helped you.

  8. #8
    Registered User
    Join Date
    08-05-2015
    Location
    SG
    MS-Off Ver
    2007
    Posts
    21

    Re: Help - How to match and return the value

    I had + Rep for both of you
    Title had been indicated as Solved.

    Once again, thank both.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help - How to match and return the value

    Happy to help, thanks for the feedback

+ 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. Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  3. Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  4. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  5. [SOLVED] Two Excel sheets trying to match text data and return the match from the second column!
    By bankcott in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 02:17 PM
  6. Replies: 2
    Last Post: 11-12-2012, 06:26 AM
  7. Replies: 5
    Last Post: 10-11-2008, 04:01 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