Sunday January 21st 2018

Categories

Insider

Archives

Vlookup function in MS Excel Example

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%