Forum Discussion

Copper Contributor

Feb 23, 2023

Solved

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
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))

MATCH.xlsx10 KB

NikolinoDE

Platinum 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))

MATCH.xlsx10 KB

jmammen

Copper Contributor

Feb 27, 2023

Thank you very much