• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLookUp currious behaviour

P

PhilipCCFE

New Member
I have a cell that contains =VLOOKUP(P5,Support!$G$13:$H$40,2,FALSE).


P5 should contain a 4 digit folder code typed by the user, however because I suspect what they will do is copy and paste the full file path in "1900 Appointments and ToR" rather than just 1900.


as such I tried using =VLOOKUP(Left(P5,4),Support!$G$13:$H$40,2,FALSE). but that returns a #N/A error.
 
The result of the Left() formula will be text, your list probably contains numbers. Use Value(Left(P5,4)) to change the text into a number.
 
You must log in or register to reply here.
Back
Top