VLOOKUPThis function is good for looking up information in big tables without having to scroll all over the place. Another idea could be to lookup share prices in a table and, by adding another couple of calculations to that formula, calculate the profitability - or list only those share prices you want to see from a huge database (for those who don't want to have the internet calculate their funds). |
Basically, VLOOKUP has 3 arguments: VLOOKUP(what to look for;in which area to search;output from which column)
|
These pages are available as print-friendly PDF (click icon). |