Lookup functions

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

I have a spreadsheet I am trying to build that has 3 tabs. The first are my
employees and thier statistics by week. What I want is on my second tab to
be able to put in a name and a week and it pull the data into the second tab,
my scorecard. The last tab is basically the same thing but I want it to pull
all 4 weeks of the month and tally an average. The lookup functions have me
completely lost right now, can anyone help me out?
 
Hi Ted,

You may be able to do what you are asking with a Pivot Table.

John
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spin Box with Dates and Lookup 5
Lookup Help... Again. 3
V Lookup & IF 3
Lookup returning wrong results 0
Excel Lookup 1
set a permentant print area in a multi-sheet workbook 1
Referring to a cell by using another cell for the row number 6
Looking for a solution 1

Back
Top