Lookup Multiple Criteria in a Table and Return Header

  • 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.



    [ATTACH=CONFIG]70415[/ATTACH]

  • Re: Lookup Multiple Criteria in a Table and Return Header


    I see that I have posted this in the incorrect forum. My apologies.


    MODERATOR NOTE - have moved to formulas forum.