Excel Forum
Similar Content
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...



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.