HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION

[CHAIM]

[kraljb]

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.