K
kraljb
Not sure which part of the left function you want it nested in... but i
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 th
numeric value with the VLOOKUP function
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 th
numeric value with the VLOOKUP function