This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
After the recent update I have tried using the VLOOKUP function and it isn't working correctly. I have a table consisting of two columns (time and temperature) and I want to find the time at a given set of intervals (say ever 10 seconds), although when trying to use VLOOKUP I only get a single solution for all the time intervals. I have used VLOOKUP a lot prior to the update and it has always worked fine, up until now. I am wondering if anyone else is having this problem?
Cheers
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What is the recent update that you have done ? Is it WINDOWS 10 ?
Try checking if the calculation is by any chance set to Manual.