Hello Everyone,
I am trying to VLOOKUP the first 5 characters of a column (column F) in column G.
EDIT: SEE EXAMPLE FILE IN 2nd POST
Cell F2 contains "ABCD112311121". I want to use VLOOKUP to simply have column G2 simply pull back "ABCD1."
I have tried =VLOOKUP(LEFT(F2,4)&"*",$F:$F,1,FALSE), and that is not working.
Column F is formatted as "general," and Column Y is formatted as general.
Halp,
JGBIII
Bookmarks