Can we use while loop in Excel sheet for getting the smallest no
I am using MS-Excel for storing more than 2000 records.<br/>
I need a formula that will take a from one cell say cell `E3` and match it with all cells in that row.<br/>
If it finds the match then it should display the value at that column's header.<br/>
lets say `E3` matches with `C3` then it should display the value which is at the `C1` cell.
Can we use while loop in Excel sheet for getting the smallest no
===

I am using MS-Excel for storing more than 2000 records.<br/>
I need a formula that will take a from one cell say cell `E3` and match it with all cells in that row.<br/>
If it finds the match then it should display the value at that column's header.<br/>
lets say `E3` matches with `C3` then it should display the value which is at the `C1` cell.