On Sep 17, 2:02*pm, Colleen10
wrote:
I have one spreadsheet that shows the original invoice # of 003567457A and
new version spreadsheet that shows the new invoice is now 003567457AR. *I'm
trying to find a formula like vlookup that will match the newer version
invoice with the older version invoice because it is "similar"

Assuming the invoice # is in A1 in the original and the new invoice is
in a table in C2:G20 and you want the value of the 3rd column

vlookup(A1&"R",C2:G20,3,false)


Burke