Excel short tips Short Tips#0054: Formula to find closest value in an array from lower side Pushpendu Roy Karmakar Sep 2, 2018 No Comments Tagged with IF, MAX See also Lesson#81: Making an automatic analog clock in excel with a pie chart About Pushpendu Roy Karmakar Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.