Find row number of text string in a range of cells

Hi Ron,

This worked perfectly! Many thanks!

Regards,
Steven

thx that was a great help actually i was doing formula for fina and match text in Column A="Alpha1" and if Text in Column B= contain "Alpha2" then export value of same row from Column C.
did something like that and it worked:
=IF(INDEX(IRLOG, IF(COUNT(MATCH("*"&$F5&"*",Comm,0)),MATCH("*"&$F5&"*",Comm,0),1), 4)="WCEL",INDEX(IRLOG, IF(COUNT(MATCH("*"&$F5&"*",Comm,0)),MATCH("*"&$F5&"*",Comm,0),1), 6),"")

IRLOG = TABLE name
F5 = Alpha2
Comm = column B list name/range
WCEL = Alpha1
6 is the column number for which i want to export the value for.