Dear all,

Can anyone please guide me on how to learn HLOOKUP, VLOOKUP, and PIVOT TABLE in Excel? I need to master these functions in Excel. Your assistance in this regard would be greatly appreciated.

Looking forward to your valuable response.

Best Regards,
Valan

From India, Madras
Acknowledge(0)
Amend(0)

Hi,

What do you want? May I send you a formula in an Excel sheet showing some data, or do you have some data for which I can create a formula?

All three formulas are very easy once the concept is clear.

Regards,
Manjay
manjay@malaygauri.com
+91 9810507200
Malay Gauri Consultants Pvt. Ltd.
www.malaygauri.com

From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Manjay,

I received your email about the Pivot table. The thing is, your data shows the final result. Could you please explain the step-by-step process of Pivot, Hlookup, and Vlookup?

Expecting.

Regards,

Valan
its.valan@gmail.com
09944284528

From India, Madras
Acknowledge(0)
Amend(0)

THIS FILE MAY HELPS YOU Try to learn with this.. otherwise i will try to explain you step by step over phone
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulae01.xls (1.67 MB, 315 views)

Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.