Im using this formula to do a Vlookup =VLOOKUP(A:A,Sheet1!A:G,7,TRUE)
Any product codes that are not numbers show as #N/A but it works when the SKU is just a number.
I have tried formatting the cells as numbers. If its general it just shows 3E+11 everywhere
Any Ideas how I solve...