Index/Match to Right 5 characters - Array

[cleokep]

Hi, wonder if anyone can help with this Index/Match based on Matching Right 5 characters?

Example Data in Sheet 1:

A	B	C
Name	ID	Location
Mark Smith	41264
Mike Smith	73894

<tbody>
</tbody>

Example Data in Sheet 2:

A	B	P	BH
Location	Address	Department1	Department45
Baltimore	100 Sycamore St	Production:41264
Kansas City	400 Main St		Engineering:73894

<tbody>
</tbody>

Here is my formula typed into Sheet 1, Column C that doesn't seem to work:
{=INDEX(Sheet2!$A$2:$A$500,MATCH(B2,RIGHT(Sheet2!$P$2:$BH$500,5),0))}

Results I want to see in Sheet 1:

A	B	C
Name	ID	Location
Mark Smith	41264	Baltimore
Mike Smith	73894	Kansas City

<tbody>
</tbody>

Thanks for any insight you can give!

 

[skywriter]

See if this works:

=LOOKUP(TEXT(B2,0),RIGHT(Sheet2!$P$2:$BH$500,5),Sheet2!$A$2:$A$500)