NikolinoDE Lap/Windows 11/ Office 365My requirment is, i need to find the colum name of between E to I which is nearest matching with the vlaue of colum D.ABCDEFGHIJSl NoSupplier NameRouteRateIndex Rate1Index Rate 2Index Rate 3Index Rate 4Index Rate 5Nearest Matching1Abc CompanyIndia-UAE $ 1,100.00230015001150900800 2Abc CompanyUAE-China $ 2,000.0035003100200017001500 3Abc CompanyGermany-UAE $ 1,700.0025002100180014001200 4Abc CompanySAUDI-UAE $ 400.00650500400350250

jmammen An example is attached to the file.=INDEX(E2:I2,MATCH(MIN(ABS(E2:I2-D2)),ABS(E2:I2-D2),0))

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.