13. Excel Tips - VLOOKUP

VLOOKUP is an extremely useful function and you should know it like the back of your hand.
In a few words, it allows you to look up a value in a table, and return another value on the same row.
In my example, you've bought yourself a massive Buy To Let portfolio, and are wondering when you can retire. On typing in the new prices, you realise this might not be any time soon.
Now, you'd like to be able to type in the purchase number, and return the new value.. so here's how to do it:
VLOOKUP example sheet
If you want to know for example the 5th property you bought, you type 5 in cell C3.
- Nick's blog
- Add new comment
- 2336 reads

Recent comments
8 min 17 sec ago
17 hours 15 min ago
17 hours 22 min ago
1 day 32 min ago
1 day 2 hours ago
1 day 19 hours ago
1 day 20 hours ago
1 day 20 hours ago
1 day 20 hours ago
1 day 21 hours ago