i have 2 sheets one has the SKU numbers and the other the SKUs with the quantity, and i would like to return the quantity from the 2nd sheet to the first sheet with a vlookup which is simple, the challenge is though all the SKUs on the first sheet starts with a few extra characters but the 2nd sheet not, and it has to stay that way, for example the SKU in the first sheet looks like this: "RCC-RUBBER67" and the SKU on the 2nd sheet looks like this: "RUBBER67".
I tried to use this formula:
=IF(A2="","",VLOOKUP(RIGHT(A2,LEN(A2)-FIND("-",A2)),Sheet2!A:D,2,0))
And it works on most cells but on some i'm getting the #N/A error, and its when the SKU looks like this: RCC-15166
It seams to work only when the SKU is letters but not numbers.
Please find the attached file example.
Any help would be highly appreciated.
Bookmarks