My favourite Excel function

I'm a self confessed Excel junkie.  I've tried other spreadsheets, but to me they just don't have the flavour of the real thing.



The Excel vlookup function is rather useful.  If you look above you can see it in action. 

In this example, we have a table of sales budget figures for each month (in green).  By changing the month number in cell D2 (in red) it gives the corresponding sales figure for the month in cell D6 (in blue).

To do this all that is required is the vlookup formula as follows:

=VLOOKUP(D2,F3:G14,2,false)

So what does that actually do?  The function looks up the value in D2 and looks for it in the first column in cells F3:G14.  It then returns the corresponding value in the second column.  Our our example the second column is the sales budget column.  Adding "false" just ensures that Excel looks for exact matches.

Our example is quite simple, but it does give a taster for what is possible with the vlookup command