Lookup first 4 character

Hi Hi,

is there any formula that can solve my following question?

Sheet 1
Column A
AAA
BBB
CCC
P/NO.RRR

In Sheet 2 A20, i would like the formula to look up for "P/NO." in Sheet 1 column A and return result of P/NO. which is "P/NO.???"
The P/no. can be at difference row.

TIA

Try

=INDEX(Sheet1!$A$1:$A$100,MATCH("P/NO" & "*",Sheet1!$A$1:$A$100,0))

will only work if there only one P/NO or if more than one will return the first

Thanks JohnTopley.
This is exactly what i what.

Thank you very much!!