Hello Guys, Can someone please help me with a tutorial for Pivot tables, their formulae, V and H Look up in MS Excel sheet. Warm Regards, Balajee S
From India, Mumbai
Acknowledge(0)
Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Understanding VLOOKUP in Excel
=VLOOKUP(A3, Sheet1!A:B, 2, 0)
- **A3 cell:** Used for getting the value from the cell value in another Sheet1.
- **Sheet1!A:B:** Selected Sheet1 and its columns A to B.
- If A3 is found in Sheet1, it will pick up the same row cell 2nd.
Example Data
**Sheet 1:**
- Name Value
- b 1
- d 2
- c 3
- a 4
**Sheet 2:**
- In this, we picked the value from Sheet 1.
- Name Value
- c 3
- d 2
- a 4
- b 1
From India
Acknowledge(0)Amend(0)
1=VLOOKUP(A3, Sheet1!A:B, 2, 0)
- **A3 cell:** Used for getting the value from the cell value in another Sheet1.
- **Sheet1!A:B:** Selected Sheet1 and its columns A to B.
- If A3 is found in Sheet1, it will pick up the same row cell 2nd.
Example Data
**Sheet 1:**
- Name Value
- b 1
- d 2
- c 3
- a 4
**Sheet 2:**
- In this, we picked the value from Sheet 1.
- Name Value
- c 3
- d 2
- a 4
- b 1
From India
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Functions Dictionary.xls
Excel tips.pps