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
- Login or register to post comments
- 15610 reads
What if "Purchase Number"
What if "Purchase Number" typed is greater than available number of stocks? I think the VLOOKUP function can be improved by IF function.
Cell C3 can be revised as follows:Cell C4 can be revised as follows:
» - Login or register to post comments
=IF(C2
=IF(C2