Kindly, can anyone help me by posting:
1. How to operate VLOOKUP and HLOOKUP in Excel?
2. What are its uses in Excel?
3. Which are the frequent formulas being used?
4. What is the simple way to understand it?
Thank you.
From India, Mumbai
Acknowledge(0)
Amend(0)
1. How to operate VLOOKUP and HLOOKUP in Excel?
2. What are its uses in Excel?
3. Which are the frequent formulas being used?
4. What is the simple way to understand it?
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
Yes sending here with all the details u need on your mail id.Still if any one has doubt you may pp drop me mail on my e mail id mukesh underscore rohila at the rate welspun dot com
From India, Jamnagar
Acknowledge(0)Amend(0)
From India, Jamnagar
Acknowledge(0)Amend(0)
Dear All,
V - Look UP Vertical Lookup
H - Look UP Horizontal Lookup
V - Look UP
In the first sheet, give 20 different numbers in a column (Passport no., Employee no., etc.).
In the second sheet, give 30 different numbers, also including some numbers that are already given in the 1st sheet.
Now, you want to see what numbers appear in both sheets (Vertically Looking).
For further clarification, please contact me via email at
.
From India
Acknowledge(0)Amend(0)
11V - Look UP Vertical Lookup
H - Look UP Horizontal Lookup
V - Look UP
In the first sheet, give 20 different numbers in a column (Passport no., Employee no., etc.).
In the second sheet, give 30 different numbers, also including some numbers that are already given in the 1st sheet.
Now, you want to see what numbers appear in both sheets (Vertically Looking).
For further clarification, please contact me via email at
From India
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.
Vlookup in Excel.xls
Excel Formulas.ppt