Not sure which part of the left function you want it nested in... but it would probably look something like this...
=LEFT(VLOOKUP(C3,$A$1:$B$100,2,FALSE),4)
or this...
=LEFT(C2,VLOOKUP(C3,$A$1:$B$100,2,FALSE))
depending on if you were looking to pull in the text value or the numeric value with the VLOOKUP function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks