Trying to use formula to find closest value to number from list in descending order
I have a list of number in descending order. With a number that doesn't necessarily match one in the list, I'm trying to locate the largest number that is still less than the number I'm looking for. I know this is possible in VBA via a loop, but I'm wondering if anyone knows how to do it with functions. See attached. FindClosestValue.xlsx
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.