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

**jtmann** · 08-10-2012, 10:37 AM

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.

**jeffreybrown** · 08-10-2012, 10:42 AM

Thanks...and now I'm hungry too

Try

Please Login or Register  to view this content.

**Ace_XL** · 08-10-2012, 10:47 AM

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!

**Max, Singapore** · 08-10-2012, 10:48 AM

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

**jtmann** · 08-10-2012, 11:36 AM

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?

**jeffreybrown** · 08-10-2012, 12:18 PM

Maybe

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

**jtmann** · 08-13-2012, 08:46 AM

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.

**jeffreybrown** · 08-13-2012, 09:24 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions