+ Reply to Thread
Results 1 to 3 of 3

Vlookup for text and add relevant values if text matches in the range

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Post Vlookup for text and add relevant values if text matches in the range

    please check the attachment, i could not make out this using vlookup, how to overcome this problem
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Vlookup for text and add relevant values if text matches in the range

    VLOOKUP does not SUM it just LOOKS UP

    Use SUMIF

    =SUMIF(H$5:H$10,B5,I$5:I$10)
    and copy down the column

    Note: You have two different spellings of Cherries (Cherrys and Cherries) they MUST be spelt the same to pick up the correct values for the total.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-19-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Vlookup for text and add relevant values if text matches in the range

    Thnak you K,

    but the the data in the columns H & I generated from Software, that user will type in such a way. software generates a text file in that format. in excel we should make values one for fruit wise.

    if you see the same for carrot it is also like car rot, i should all the values of same carrot in to one. how can i get done this using =LOOKUP(2^15,SEARCH(TRIM(LEFT(b5,4)),$h$5:$h$10),$i$5:$i$10) something like this, i have tried but not successful.

    if you can help me out using some improvement.. it would be something like 1000rows aboe with different spellings

+ 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: 2
    Last Post: 08-05-2013, 07:32 PM
  2. If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?
    By eliot1171 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 09:41 PM
  3. Changing format of cells that contain multiple matches of text taken from Vlookup
    By fallwire in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2010, 08:50 PM
  4. [SOLVED] similar text matches vlookup
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2006, 05:25 AM
  5. Find the POSITION IN A RANGE of text in a string that matches value(s) in a range
    By Cornell1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 03:25 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