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
MS-EXCEL - INTRODUCTION TO PIVOT TABLES.pdf