+ Reply to Thread
Results 1 to 4 of 4

Sverweis/ Look ups

  1. #1
    Registered User
    Join Date
    01-29-2020
    Location
    Salzburg
    MS-Off Ver
    Office 2010
    Posts
    2

    Sverweis/ Look ups

    Hi there,

    I try to get a shift sheet for a little job I might do but i have a problem there......
    The shifts a changing day by day during a month.....so for instance Tuesday you have an A 6 Shift what means you work from 16:00 till 21:00 and Wednesday you have an B 7 Shift what means from 07:00 till 15:30.

    I created a table for me with the complete month and I have all the posible shifts included.

    What can i do, to only write f ex A 6 and the start and end times of the shift will be filled in automaticly.

    See the attached table. The shifts are called DIENST in german.

    Thank you for your help!

    Cheers

    P.s. Please dont look at the grammer of my english, as I am German and I started with Excel only recently.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-23-2014
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel Office 365
    Posts
    32

    Re: Sverweis/ Look ups

    Hi there, sorry but looking at your attachment, it seems like you've already figured out a VLookup to do what you need. Do i understand incorrectly?

  3. #3
    Registered User
    Join Date
    01-29-2020
    Location
    Salzburg
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: Sverweis/ Look ups

    Hi,

    no....I am always get this error NV.....so on the table all the other boxes I can't get working.....Don't know where my mistake is.

    Cheers

  4. #4
    Registered User
    Join Date
    01-23-2014
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel Office 365
    Posts
    32

    Re: Sverweis/ Look ups

    Ok, try this. I simply added an "ISNA" formula to Columns C & D formulas and an "ISERR" formula to the E column.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1