So, I need a formula that searches for a cell in a specific row (or one of multiple rows) by its text, then displays the value of the cell to the right of it. I don't even know how to begin to do this one...

Here's an example of this:

Here is an example of a list of phrases with associated numbers that'll come up later in the sheet.

Here I want a formula that searches for instances of the word in the cell to its left appearing in Column A, and then display the value of the cell to the searched cell's right. Note that I'm only searching for phrases that come up once...

...and this is what I'd want the result to be.

(I'm on mobile, if that affects anything.)

EDIT: Also I've realized, unlike in the image the formula would actually be searching for a phrase TWO cells to its left instead of one, sorry!

CodePudding user response：

try in H26:

=INDEX(IFNA(VLOOKUP(G26:G, A:B, 2, 0)))