Lookup project name using variable-length project number that is also part of project name

Hello,

I'd like to find a formula for cell D2 in the sample spreadsheet below.

Greenshot 000077.png

The formula in D2 should:
-- check cell D1 to learn which project's full name is desired
-- look up that project number/name in column A
-- display the full name of the project (which should begin with the same project number)

Please note that:
-- column A may include blank cells.
-- the projects listed in column A may be in any type of order (they are not guaranteed to be in numeric order)
-- the project numbers which are part of each project name may be 3 to 6 digits long


Thanks for your suggestions!

JayUSA

For future reference, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Based on what you showed, try this...

	A	B	C	D
1	1234 abc		234	1234 abc
2	2466skzdj

D1=INDEX($A$1:$A$2,MATCH("*"&C1&"*",$A$1:$A$2,0))

Happy to help