Partial lookup issue

[blopez5518]

Hello Everyone,

I was hoping someone could help me with a formula for a similar situation to what I have below. I know I can use an index/match formula to match B2 to column A and pull "The Snow is white". But I can not seem to find a way to do it the other way around.

	A	B	C
1	The sky is blue <tbody> </tbody>	white <tbody> </tbody>	does anything in A2 match any cell in Column B <tbody> </tbody>
2	The grass is green <tbody> </tbody>	blue <tbody> </tbody>
3	The snow is white <tbody> </tbody>	green <tbody> </tbody>

<tbody>
</tbody>

 

[pgc01]

Hi
Welcome to the board

Try in C1:

=LOOKUP(2,1/SEARCH($B$1:$B$3,A1),$B$1:$B$3)

Copy down

 

[blopez5518]

You are amazing, that worked perfectly!

 

[pgc01]

I'm glad it helped.