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.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=390712