Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Kent, England
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello all,

    It's been a good while since I last posted here.

    Have a dashboard which I want to populate with data depending on the selected service name and selected month.
    I have set up my dynamic named lists and created the dropdowns at the top of my dashbaord and now I want to be able to populate various areas of the dashboard using information held in tables in other sheets.

    I want a formula that looks up the date and the service name and can then supply me with the figure from the table.
    I am sure this is very straight forward, but I only know about VLOOKUP and HLOOKUP and it seems I need some sort of combination of the two.

    I'm not sure I have explained this problem very well, I hope you can help.

    Thanks

    Emily

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Welcome back to the Lounge!

    You can probably use a combination of INDEX and MATCH. The formula could look like this:

    =INDEX(table, MATCH(selected_service, list_of_services, 0), MATCH(selected_month, list_of_months, 0))

    but of course the exact form depends on the layout of your data. If you'd like more specific help, it would be useful if you could attach a small sample workbook.

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    Kent, England
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans, I'll give it a go.

  4. #4
    New Lounger
    Join Date
    Oct 2002
    Location
    Kent, England
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am now investigating a combination of VLOOKUP and MATCH.

Posting Permissions

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