I have the attached workbook.
I need help with the followings. the solution i need is via VBA, not formula.
on the Sheet("Data") at the end of column meaning the next available column, insert column returning Description from the table for the PRODUCT column.
This does two VLOOKUP formulas, the first takes the whole of the product column and checks the lookup table for that value and returns the value from the second column of the lookup table; if the first VLOOKUP gives an error, it takes the first character of the product and adds "*" and then looks for that value in the lookup table.
With your data, there are two lines that give an error. They are both product code beginning with 1 which doesn't show in the lookup table.