Dueling Excel 041


VBA or Formula Extract Prefix for VLOOKUP

DESCRIPTION

See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. See the functions: LEN, INDIRECT, ROW, MID, ISERROR, MATCH, LEFT and VLOOKUP.
Learn how to copy a sheet and paste a defined name with keyboard shortcuts.

WORKBOOKS




Be the first to comment

Leave a Reply