I'm usually fairly decent when it comes to Excel formulae but this one has me stumped. I've been given a table (Columns K-P) and a "current value" and "percent off" (Columns R and S). Using this information, I have to find where the percent off (column S) falls in the table, check that row for what's closest to the current value (Column R) and return the header information (Column T).
Is this even possible? Any help would be very appreciated.