Actually I was able to make the formula work by playing around with it a bit
but interestingly in some cases it returned the full value of the "R invoice
but other times it just returned the "R" itself. Looks like some of the
cells were formatted or maybe were not numeric value...it's ok, I can fix
these with a concatenate. Thanks so much

"Burke" wrote:

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