HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF statement 4
Nesting Functions 4
Nested functions using array/range names 3
Help With VLOOKUP 2
maximum nested IFs 6
Nest vlookup within large function 3
Vlookups not working 2
Nesting Lookup Functions 4

Back
Top