I want to compare a value in one column with values in other three columns, then output the closest value (without going over) and the column name of the closest value.
For example, I want to compare the value in Y4 col to Y1,Y2 and Y3 and output the results in Closest Value and Closest Column.
Y1 Y2 Y3 Y4 Closest Value Closest Column
20% 30% 21% 19% 20% Y1
19% 20% 18% 17% 18% Y3
I need an excel formula not the VBA code. I'd greatly appreciate any help!