|
|
Featured Tutorial
Featured Macro
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
Complex text extract formula that extracts text to use in VLOOKUP to lookup values and return data. See these Tricks:
1. Extract all letters from text string
2. Use extracted letter array in MATCH function
3. Lookup Last Number Trick (Big Number Trick BigNum)
4. Lookup First Number Trick (TRUE in MATCH lookup value)
5. Use MATCH function & Lookup last and first number formula element in MID to extract the Mixed Number & Letter Partial Text.
6. Use the Partial Text in VLOOKUP and INDEX formulas to lookup and retrieve values.
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Extract all letters from text string
2. Use extracted letter array in MATCH function
3. Lookup Last Number Trick (Big Number Trick BigNum)
4. Lookup First Number Trick (TRUE in MATCH lookup value)
5. Use MATCH function & Lookup last and first number formula element in MID to extract the Mixed Number & Letter Partial Text.
6. Use the Partial Text in VLOOKUP and INDEX formulas to lookup and retrieve values.
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm