Lookup unknown number in a row based on a range

Hi All,

Very new to forums, and hope this is the right area for my query.

I have a 5 columns containing either numbers or text and I need to lookup a number that appears in each row between a range.

here is an example:
Reference Number 2 Reference Type 3 Reference Number 3 Reference Type 4 Reference Number 4 Return value here
SYDNEY ORDER NUMBER 577552 PRODUCT CODE 80300453
574597 ORDER NUMBER 80298772 PRODUCT CODE RESEARCH

I need to return any number in each row between 80000000 and 89999999
As you can see, the text and numbers dont always appear in the same row

Thanks in advance

Thanks for the quick reply, attached a work book.,

There are 2 worksheets, 'data' contains raw data, 'desired result' shows what i need to accomplish

thanks again
Joe

Try this in F2:

=LOOKUP(2,1/(A2:E2>=80000000)/(A2:E2<=89999999),A2:E2)

this probably seems so basic to you - i was working on this for days and you solved it in like 5 minutes
thanks VERY much, you are amazing!!!

kind regards
Joe

both =LOOKUP(2,1/(A2:E2>=80000000)/(A2:E2<=89999999),A2:E2)
& =INDEX(A2:E2,,MATCH(80,INDEX(LEFT(A2:E2,2)+0,),0))
return what I am looking for - thank you both VERY much!!!