SOLVED

# Excel formula

Copper Contributor

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

3 Replies

# Re: Excel formula

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

best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Excel formula

An example is attached to the file.

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

# Re: Excel formula

Thank you very much
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Excel formula

An example is attached to the file.

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