vlookup Help!

T

Tommy329

I have a Excel workbook which has multiple worksheets (tabs) tracking my
agents stats from day to day. My data is not on the same identical cells from
worksheet to worksheet. I am trying to use a Vlookup fuction to pull the
specific data that I want from each worksheet, and get a return SUM total for
my summary page. I hope you can hlep me with this problem or have a better
solution. Thankyou Tommy
 
L

L. Howard Kittle

Hi Tommy,

Maybe I an give you a small example and you can expand it to suit.

Formula in sheet 1, A1 =VLOOKUP(B1,Sheet2!A1:B5,2,0)
Data on sheet 2 A1:A5 = A,B,C,D,E, which represent the salesman name.
Data on sheet 2 B1:B5 = 1,2,3,4,5, which represents the sales figures for
the salesman in column A of sheet 2.
Formula in in sheet 1, A2 =VLOOKUP(B2,Sheet3!E1:F5,2,0)
Data on sheet 3 E1:F5 = F,G,H,I,J, which represent the salesman name.
Data on sheet 3 F1:F5 = 6,7,8,9,10, which represents the sales figures for
the salesman in column E of sheet 3.
Formula in A3 =SUM(A1:A2)
Enter salesmans name in B1 and B2 on sheet 1.

Regards,
Howard
HTH
 
Top