Excel Forum

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

Got a Question? Ask it Here in the Forum.