mercredi 25 mars 2015

VLOOKUP IN EXCEL DOES NOT FIND THE VALUE IN AN ARRAY DESPITE OF AVAILABLE

Today, I met an interesting problem while I was working in EXCEL.


I used VLOOKUP function to find a value in an array but some of the values gave #N/A answer despite of available in array.


The EXCEL image is in this link:


http://ift.tt/1GjH9pu


To round up the numbers, I used CEILING function but interesting point is in some values, it did not work.


I checked the type of value if it is number or not.


Also, I used ROUNDUP function but did not work.


Also, I tried INDEX/MATCH combination and again did not work.


In the example that I gave in the link, when I type between 15.00 - 15.20, it gives error but trying other values, it works.


How is the solution of this problem?


Aucun commentaire:

Enregistrer un commentaire