Avatar of pmandair

asked on 

Find the closest value in columns in excel


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!

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon