Good am/evening guys!
I encounter a problem with the number digit using VLOOKUP
in B1 if I input range from 001 to 871 (Format: Text) it will show the output BUT if I input 872 to 1000 the output will be 1161 but when you search the 872 the value is 872 and not 1161
is there a limit to it?
the range are from A4:B1164 like that..
here's the perfect sample...
sample.xlsx
I can input only from 001 to 871... but when I input 872 the result will be 1161 it must be 872
PROBLEM SOLVED!
here's the link
Last edited by MeSH16; 04-07-2015 at 11:37 AM. Reason: SOLVED!
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
If posting code please use code tags, see here.
Sir I currently upload a file but I edit my first post but still it's similar problemOriginally Posted by Norie
Amend your formula to
=VLOOKUP(B1,A4:B1164,2,FALSE)
and it seems fine...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
thanks it works! I'll edit my post and mark it SOLVED! and will add to your REP
hope you can also visit my thread. I really need to fix that problem.. thanks in advance!
Last edited by MeSH16; 04-07-2015 at 11:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks