Doingvlookup search for partial value of serial numbers

[Buddynbella]

I am trying to figure how to enter a formula that would greatly help my work team. We have serial numbers of machines that are converting formats. An example of a previous machine serial # is 70600007 which has recently been converted to K5970600007 - which are the same 8 digits in each. Monthly we do an upload that includes also the meter reading for a machine in another column. Say the sheet is set up with column A, B, and C.

New Old Meter read
<TABLE style="WIDTH: 203pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=270><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d0e3d3; BORDER-LEFT: #d0e3d3; BACKGROUND-COLOR: transparent; WIDTH: 89pt; HEIGHT: 15pt; BORDER-TOP: #d0e3d3; BORDER-RIGHT: #d0e3d3" height=20 width=118>K5970600007</TD><TD style="BORDER-BOTTOM: #d0e3d3; BORDER-LEFT: #d0e3d3; BACKGROUND-COLOR: transparent; WIDTH: 67pt; BORDER-TOP: #d0e3d3; BORDER-RIGHT: #d0e3d3" width=89 align=right>70600007</TD><TD style="BORDER-BOTTOM: #d0e3d3; BORDER-LEFT: #d0e3d3; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #d0e3d3; BORDER-RIGHT: #d0e3d3" width=63 align=right>133596</TD></TR></TBODY></TABLE>

The meter reading is only associated with the old, now incorrect, serial number. How would the formula be written to match the meter reading to the new serial #? I tried =VLOOKUP(B:B,RIGHT(D1:D286,8),2,FALSE), but it is not working. Thank you!

 

[VoG]

Maybe

=VLOOKUP(RIGHT(A1,8)+0,B1:C1000,2,FALSE)