VLOOKUP only if partial text is found

[grant langley]

Hi,

i am trying to return a date from a data set using vlookup, only if certain text is found.
I am not having any luck with the formula. any ideas?


eg - return G1, from data A1:G10, only if B1 contains text "Independent Tanks".
The red text would be my lookup value.

=IF(ISNUMBER(SEARCH("Independent Tanks",Sheet2!B1)),VLOOKUP(LLI!D13&"*",Sheet2!$B$1:$G$43,7,FALSE),"na")

Capture.JPG

[63falcondude]

Hello and welcome to the forum.

It would have helped if you were to upload a sample workbook instead of a picture of one. This way, we don't have to re-create it to test.

That being said, try this:

=INDEX(G:G,MATCH("*Independent Tanks*",B:B,0))