Help!! Summary table using another table

Alpacino

Well-known Member
Joined
Mar 16, 2011
Messages
510
Hi everyone, I'm struggling to do a summary table using info from a table. The table has lists going down column A e.g. Row 1 (Sales), row 2(waste), row 3 (wages). Column 2 and so on has wk numbers in them with their actual figures in cells e.g. Wk 1 sales 45k wk 2 46k. What I would like to do is create a summary like vlookup??? to select Kpi and wk nber to give me the cell data. Anyone help??
Thanks in advance
Alpacino
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Alpacino

Well-known Member
Joined
Mar 16, 2011
Messages
510


What I would like is a summary box to find out what happened on the 3/17.
Anyone help??
 

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,295
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top