A Drop of Excel - 11 | $ referencing, How to use Vlookup in most simplified method, Xlookup in Excel

Опубликовано: 12 Апрель 2020
на канале: Excel Rush

1,960

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
https://drive.google.com/file/d/1We1k...

\ Previous video:    • A Drop of Excel - 10 | Paste Special,...
/ Understanding of the data being used in the examples:    • A Drop of Excel | Understanding the d...

Related Videos/Posts
18 Most Useful Excel shortcuts --    • 18 Most Useful Excel Shortcuts