I have the formula below working like I want but I need to add ONE MORE criteria: the returned value must also have a rating of "AA" in column P2:P14. How in the world do I do this??
Thanks!
Code:
=INDEX([COLOR=#F7981D]O2:O13[/COLOR],MATCH(MIN(ABS([COLOR=#7E3794]K2:K14[/COLOR]-[COLOR=#11A9CC]S2[/COLOR])),ABS([COLOR=#7E3794]K2:K14[/COLOR]-[COLOR=#11A9CC]S2[/COLOR]),[COLOR=#1155CC]0[/COLOR]))
Thanks!