This tutorial focuses on cleaning date/time data so that you can use it in lookups. Notesĭates and times in Excel are often tricky to deal with. If you want to test out the Vlookup with and without the ROUND function, try it on the 10:34 time without ROUND, it returns "value 4" and with it, it returns "value 5". Now you have a working lookup on a table of dates and times.However, you must include the ROUND function or this will not work since we already rounded the date/time values in our list. Without the ROUND function, the VLOOKUP function would have looked like this, with only D4 in for the lookup_value: The ROUND part has been highlighted for you. The Vlookup function, or whichever lookup function you use, now needs to be adjusted to work with the rounded numbers.Įnter a normal Vlookup function BUT put ROUND(lookup_value ,5) in for the lookup_value argument.This means that the date and time that you see will actually be the date and time that is stored. Then, delete the new column that you created with the ROUND() function. Now, your old data will have been replaced with the new data and it will have been rounded to the 5th digit after the decimal point. ![]()
0 Comments
Leave a Reply. |