Vlookup on phrase in large block of text

[toddlerzz]

I am trying to do a vlookup on a phrase from a block of text to return a value.

For example, on Sheet 1, in column A I have work boots

Then on Sheet 2 in column A it one cell it says blue jeans work boots hard hats spikes all in the same cell with the number 12 then in column B

I need a formula that would look for the data in sheet A1, in this case work boots through all of the data in column A on sheet 2 and then return the value in column B when it finds it.

Thanks.

 

[T. Valko]

I am trying to do a vlookup on a phrase from a block of text to return a value.

For example, on Sheet 1, in column A I have work boots

Then on Sheet 2 in column A it one cell it says blue jeans work boots hard hats spikes all in the same cell with the number 12 then in column B

I need a formula that would look for the data in sheet A1, in this case work boots through all of the data in column A on sheet 2 and then return the value in column B when it finds it.

Thanks.

Try this...

=VLOOKUP("*"&A1&"*",Sheet2!A2:B10,2,0)

Adjust the ranges to suit.

 

[toddlerzz]

That does the trick. Thanks so much for the quick response!!

 

[T. Valko]

That does the trick. Thanks so much for the quick response!!

You're welcome. Thanks for the feedback!