ExcelBanter - partial lookup/match

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - partial lookup/match (https://www.excelbanter.com/excel-worksheet-functions/87671-partial-lookup-match.html)

myra_deV

partial lookup/match

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?

All times are GMT +1. The time now is 04:25 PM.