The Power of VLOOKUP() in Excel

VLOOKUP() - a widely used function in Microsoft Excel - has it's own powers in the way you use it.

Its arguments are:

1. lookup value
2. table array
3. column index number
4. range lookup

It becomes more powerful when you make the column index number variable by putting a cell reference in it as mentioned in the below example


=VLOOKUP(C8,D10:I19,D7,FALSE)

Here the value being returned by the formula will be determined by the value in D7.

---