Forum Discussion

jmammen's avatar
jmammen
Copper Contributor
Feb 23, 2023

Excel formula

NikolinoDE  Lap/Windows 11/ Office 365 My requirment is, i need to find the colum name of between E to I which is nearest matching with the vlaue of colum D. A B C D E F G H I J Sl N...
Excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Feb 23, 2023

    jmammen 

     

    An example is attached to the file.

    =INDEX(E2:I2,MATCH(MIN(ABS(E2:I2-D2)),ABS(E2:I2-D2),0))

     

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 23, 2023

jmammen 

 

An example is attached to the file.

=INDEX(E2:I2,MATCH(MIN(ABS(E2:I2-D2)),ABS(E2:I2-D2),0))

 

  • jmammen's avatar
    jmammen
    Copper Contributor
    Feb 27, 2023
    Thank you very much

Share

Resources