A Drop of Excel - 11 | $ referencing, How to use Vlookup in most simplified method, Xlookup in Excel
Vlookup seems very confusing and you may often forget it even if you have learnt it earlier.
We will here learn Vlookup in a very simplified manner that you will not forget.
$ referencing is also a must to learn to understand how to make cell references constant in formulas.
Xlookup has been recently released by Excel and is much easier to use even than Vlookup!
We will also be learning about IfError with Vlookup, which is made a part of the new Xlookup.
* Example file link
drive.google.com/file/d/1We1k...
\ Previous video: • A Drop of Excel - 10 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
18 Most Useful Excel shortcuts -- • 18 Most Useful Excel S...
Пікірлер: 4
Finally had my concepts cleared.. very nicely explained..thank you
Very Interesting & Useful ! Thank you for making it very easy.
Whats the difference between Vlookup & Xlookup?
@Excelrush
4 жыл бұрын
The objective of both is same, difference is the way the functions are written. Also, IfError has to be written separately in Vlookup, whereas it is inbuilt in Xlookup.