Results 1 to 3 of 3

Thread: Table look up

  1. #1
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    Unanswered: Table look up

    My company would like me to update a workbook that tracks our employes travel, like who and how much. There is an overal sheet (which is our whole organization), each team has a sheet, then a sheet with all the data on it. All the sheets pull from the data sheet for all the numbers then there's a graph for all this, that was easy. Now they want the people who will be traveling in the current month. to be displayed automaticallly along side the chart. Can anybody help me with a funtion to do this?

    I was thinking about doing a vlookup, but I need to get a set of rows and not a single value.
    Ryan
    My Blog

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    What about a pivottable?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I haven't had experience with these. I thought they were to allow people to compare data in different ways.
    Ryan
    My Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •