Forum Discussion
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 |
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
- Thank you very much
