lookups and pivot_table_in_excel
DESCRIPTION
This technical document helps to business and management to create Lookups and Pivot table in Microsoft Excel.TRANSCRIPT
![Page 1: Lookups and pivot_table_in_excel](https://reader036.vdocuments.us/reader036/viewer/2022081518/5461f703af7959f84e8b4ca6/html5/thumbnails/1.jpg)
This is How Vlookup works in Microsoft Excel:
This is How Hlookup works in Microsoft Excel:
This is How both (Vlookup & Hlookup) works when both fetching data from different worksheets:
![Page 2: Lookups and pivot_table_in_excel](https://reader036.vdocuments.us/reader036/viewer/2022081518/5461f703af7959f84e8b4ca6/html5/thumbnails/2.jpg)
This is How Vlookup works when fetching data from different Excel sheet:
![Page 3: Lookups and pivot_table_in_excel](https://reader036.vdocuments.us/reader036/viewer/2022081518/5461f703af7959f84e8b4ca6/html5/thumbnails/3.jpg)
This is How Hlookup works when fetching data from different Excel sheet:
This is How Pivot Table displays data in Graphical mode from different workbook:
![Page 4: Lookups and pivot_table_in_excel](https://reader036.vdocuments.us/reader036/viewer/2022081518/5461f703af7959f84e8b4ca6/html5/thumbnails/4.jpg)