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
From India, Mumbai
=VLOOKUP(A3,Sheet1!A:B,2,0)
A3 cell:- for getting the value from cell value in other sheet1
Sheet1!A:B:- selected Sheet1 and its column A to B
If A3 found in Sheet1 it will pick up the same row cell 2nd
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
1A3 cell:- for getting the value from cell value in other sheet1
Sheet1!A:B:- selected Sheet1 and its column A to B
If A3 found in Sheet1 it will pick up the same row cell 2nd
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
pl find attached xls w I called data in sheet2 from sheet 1, the unique key between is name
From India
From India
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
MS-EXCEL - INTRODUCTION TO PIVOT TABLES.pdf
The wonders of Ms excel.zip