INDEX, MATCH and RIGHT

Hey,

I am trying to match two values on the last 14 digits of the string.

Example:

Match:
8993017100193540280F
w/
89930107100193540280F

I can do it if I create a separate column with a separate RIGHT formula on each tab and then index but I would like to try and get it into one formula.

I thought if I just added the right into the formula it would work:
=INDEX(Index!A1:A5,MATCH(RIGHT(A1,14),Index!B1:B5,0))

but it seems I need to get the index to right as well.

Attached an example.

Any help greatly appreciated!

How about
=INDEX(Index!A1:A5,MATCH(RIGHT(A1,14),RIGHT(Index!B1:B10,14),0))

Might need Ctrl Shift Enter, rather than just enter.

it is the Index - needs to be 1

=Index(Index!$A$1:$A$5,Match(Right($A1,14),Index!$B$1:$B$5,0),1)

Also you probably want to use fixed ranges ($) because when you copy down you don't want the Index and Match ranges to move

Sorry - should have looked at the workbook... I cede to Fluff's idea

=INDEX(Index!A:A,MATCH(RIGHT(A1,14),RIGHT(Index!B:B,14),0))

Fluff worked perfectly thank you!!

You're welcome & thanks for the feedback.