Results 1 to 3 of 3

Thread: Look up formula or help

  1. #1

    Look up formula or help

    Register for a FREE account, and/
    or Log in to avoid these ads!


    Looking for a bit of help with my shift rota spreadsheet. On the Schedule part of the sheet I choose the names of people doing the shifts and there hours are auto calculated on employee hours page.

    However what im looking to do is have an auto look up on Shifts by name page where it looks to the schedule and pulls over the data to the corresponding name, ie shift and time.

    I have attached the spreadsheet to this thread any help is appreciated.

    Thanks in adavanceNEW DUTY SHEET 06052011 (Autosaved).xls

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    Hi there,

    Welcome to the forum, and sorry it took so long to get an answer back to you. I was ridiculously busy this past weekend.

    I've filled in some formulas for you, but I'll warn you that th formula to pull back the hours is fragile. Your data sheet is in a difficult format to work with. With multiple rows for some areas and not others, it takes some work to make sure the right data is coming back.

    At any rate, this sure work for you.

    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Manchester, England
    Excel Version
    Excel 2016
    I agree Ken, whilst you have provided a solution i really think that the workbook layout and structure should be reworked, it's likely to become unmanageable in it's present form.
    Kind regards,
    Simon Lloyd

Posting Permissions

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