i have 2 worksheets. the 1st contains a table of companies with their
industry codes (4digits) and the 2nd sheet contains tables with industry
codes and data.
my problem is i have to match the codes in the 1st sheet to the data on the
2nd on either the first 4, 3 or 2 digits of the code. how do I incorporate
this into my VLOOKUP function?