How to used VLOOKUP with Excel tables is explained in this video. When the source data is in the form Excel Table, it is easier to perform lookup into different sheets.

Intro (0:00)
VLOOKUP in a Normal data range (0:22)
VLOOKUP with Excel Tables (2:20)
VLOOKUP from another worksheet (5:30)

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

#Excel #ExcelTable #Vlookup