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.