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.
IT Counts is lucky enough to have its own Excel guru in
Simon Hurst, but I thought I would add to the mix my favourite Excel function.
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. More in Part 2.