Find text based on condition

Hello,

i want to find some specific text based on condition.its look like Vlookup but lookup value is in finding array table is contain some text, please find the attachment for clear understand ..

i have a two type of raw data in "Sheet 1" , in table to i have a parameter name that is my lookup value. so here in H2 cell i have text "page.location.domain"

i have to find the this text in "A Column" if that is match i want to bring the "WT Parameter value to " J column " its like vlookup formula. but in table 1 , A4 cell lookup value contains with some extra text "events.domain OR page.location.domain" . so please suggest me for how to get this ..


Thanks,
Ganesh

Try

=IFERROR(INDEX($B$3:$B$103,MATCH("*" &H3&"*",$A$3:$A$103,0)),"")

Hi
Use

Formula:

Please Login or Register  to view this content.

and copy down

thank johan. this what i want ....

hi this also simplest method and the best ....thanks you Jose...

hi ,

these formula helping me only for text values not for numbers ...