Summary sheet with Vlookup

  • Thread starter BNT1 via OfficeKB.com
  • Start date
B

BNT1 via OfficeKB.com

Hi
I have looked on threads for summary sheet, with or without VBA, however, my
sheets in the work book are all the same format, except that the names in
column A are not always in the same order. and therefore using the same cell
on each sheet is not an option
Can anyone suggest a way forward?

thanks

Brian
 
B

BNT1 via OfficeKB.com

Hi Anne

I have tried to interpret these pages, however, still struggling

I have sheets named, 1,2,3,4 etc. All the persons names in these sheets are
always in column A, and the cell i require is next to it, on the right.

In my summary sheeet, i have the sheet names in B2,C2, D2, etc. the names of
the people in column A3,A4 etc

I have tried =sumif(A3:A5,"Dave",B2&!A2:A5,B2&!B2:B5) obviously with no joy

Can you help me out?

regards



Anne said:
Try to find the appropriate SUM/SUMIF example here:
http://www.officearticles.com/excel/index.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
Hi
I have looked on threads for summary sheet, with or without VBA, however,
Click to expand...
[quoted text clipped - 8 lines]
Brian
Click to expand...
Click to expand...
 
Top