| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup performs inconsistently with decimals in lookup value form
Hi
The problem is caused because many numbers cannot be represented accurately in binary. If you use the Round function, then the Vlookup will work =VLOOKUP(ROUND(A54-100,1),$A$1:$B$25,2,0) Note: I assume the ,1,0 in your posted formula was a mistype, as ,1 would have returned the number in column A not the value of Tomatoes from column B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a drop down list that performs a task | Excel Discussion (Misc queries) | |||
| filling a form in Excel... lookup? maybe? | Excel Discussion (Misc queries) | |||
| Free Software that Performs 3D XYZ Plotting w Excel Data? | Excel Discussion (Misc queries) | |||
| How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) | |||
| Performs illegal operation on save | Excel Discussion (Misc queries) | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
