+ Reply to Thread
Results 1 to 8 of 8

Formula with specific text that inserts value from BESIDE cell with specific text.

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Formula with specific text that inserts value from BESIDE cell with specific text.

    I am trying to find a formula that finds a cell with specific text then pulls the data from the cell immediately beside the cell with text.

    An example of what I have and what I am looking for is attached (and you can probably tell that I am very hungry

    ~terri m.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,064

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    Thanks...and now I'm hungry too

    Try

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    If your list is in Sheet 1 and might grow in size, why not simply use in Sheet2

    =Vlookup(A1,Sheet1!$A$1:$B$10,2,False) where A1 is the food stuff.

    I am hungry too now!
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    You could also use an index/match
    Assume F2 down will contain the food names, eg: cheeseburger 1
    Put in G2: =IF(F2="","",INDEX(B:B,MATCH(F2,A:A,0)))
    Copy down
    Last edited by jeffreybrown; 08-10-2012 at 10:52 AM.
    Max
    Singapore

  5. #5
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    Thank you thank you thank you...... and since you were so good...... now I need a very similar formula that finds values beside cells with specific text but the text is not constant. The prefixes are constant but the root words change.
    excel_forum_example III-page-001.jpg

    I really hope that image shows up, I can't figure out how to attach a file to a reply?

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,064

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    Maybe

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    ooooohhhhhhhhh you are sooooooooooooooooo wonderful. THANK YOU sooooooooooooooo much. Those worked perfect and now I get to go wow all the peeps that I work with by saving the lab sooooooo many man hours.

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,064

    Re: Formula with specific text that inserts value from BESIDE cell with specific text.

    You are welcome and glad it works for you. Thanks for the feedback

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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