I am working on a forecasting spreadsheet and have item numbers in column "a"
and # sold in column "b". I have run subtotal so it has added the word
"total" to the end of the part number. I then copied just the totals to
another worksheet and I am trying to use the lookup function but it won't
look up these "total part numbers" because it no longer matches my part
numbers. My problem is that my part numbers are all over the map as far as
length. Some are as short as 6 digits and some can be 13 or 14 digits so I
can't use the left function. Any suggestions?