Excel Forum

Excel Magic Trick 303: VLOOKUP from middle of text-string

See how to use VLOOKUP function formula when the lookup item is in the middle of a product code (text string). See the VLOOKUP, REPLACE & LEFT functions in one formula.

VLOOKUP partial text.

Got a Question? Ask it Here in the Forum.