Excel formula

[jmammen]

@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 No	Supplier Name	Route	Rate	Index Rate1	Index Rate 2	Index Rate 3	Index Rate 4	Index Rate 5	Nearest Matching
1	Abc Company	India-UAE	$         1,100.00	2300	1500	1150	900	800
2	Abc Company	UAE-China	$         2,000.00	3500	3100	2000	1700	1500
3	Abc Company	Germany-UAE	$         1,700.00	2500	2100	1800	1400	1200
4	Abc Company	SAUDI-UAE	$             400.00	650	500	400	350	250

[#2]

@jmammen 

With your permission, if I may recommend, describe the steps or your goal in more detail, so you could come up with a solution proposal faster and more precisely.

here is some information about it:

Welcome to your Excel discussion space!

Thank you for your understanding and patience

[#3 · Accepted solution]

@jmammen 

An example is attached to the file.

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

[#4]

Thank you very much