• 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 not working

S

Shazz

Member
I have a simple VLOOKUP Formula that I just can not get to work.

Code: 
=VLOOKUP(L3,WkNos,2,FALSE)

Can anyone advise what I am doing wrong please.

Shazz
x
 

Attachments

  • Book1.xlsm
    55.9 KB · Views: 6
Try,

=VLOOKUP(0+L3,WkNos,2,FALSE)

p.s. Your L3 formula MID() return a text value, so using 0+L3 to convert it to a numeric value

Regards
Bosco
 
You must log in or register to reply here.
Back
Top