Hi,
I use vlookup to get data from another coloum.
I copy-paste the data and the formula, but in some row the result of vlookup is N/A.
The type of data is the same and I don't change the formula.
any idea?
please see the attachment for the file.
Thanks
change the "false" to "true"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
If I change the 'false' to true, the result is wrong.
The 2nd coloum is formula with "false".
ScreenHunter_02 Jun. 11 08.30.gif
seemingly, the percentages, division, rounding et al are playing mischief. i can't seem to attribute it to anything else.
i found an ugly way around it. in the worksheet that you uploaded in post #1, place this in G2 and drag-fill down:
=VLOOKUP(B2*1000/10,$P$2:$Q$27,2,FALSE)
or
=VLOOKUP(B2*1000/10,$P$2:$Q$27,2,TRUE)
ostensibly, results are spot on (except for 118, which appears twice in the table_array with different corresponding alphabets - FALSE gets H, TRUE gets I).
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Try =VLOOKUP(ROUND(B2*100,2),$P$2:$Q$27,2)
You have two corresponding values for 118 in your VLOOKUP table
118 H
118 I
The VLOOKUP will not work in this instance.
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kamui 
Register To Reply
Bookmarks