Vlookup function in MS Excel searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. In the example below we can find the taxrate based on income. Here income is 1,11,300 and tax rate is 45.25% because income is greater than 284701. Excel has it own very important role in data analyses and will continuously write useful MS Excel spread sheet function.
| Income is >= | Income is <= | Tax rate |
| 0 | 2650 | 15% |
| 2651 | 27300 | 28% |
| 27301 | 58500 | 31% |
| 58501 | 131800 | 36% |
| 131801 | 284700 | 39.60% |
| 284701 | 45.25% | |
| Enter Income | 1,113,000 | |
| The Tax rate is | 45.25% | |
