+ Reply to Thread
Results 1 to 5 of 5

Vlookup to automate discharge slips

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    India
    MS-Off Ver
    google sheet
    Posts
    12

    Vlookup to automate discharge slips

    Finding it hard to automate filling up of discharge slips using vlookup function.

    On the 2 nd sheet (discharge), i want to search for a name. After the name is searched the details needs looking for data from master data sheet.
    Trying to digitise the entry at quarantine facility (which is a real project)


    thanks.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Vlookup to automate discharge slips

    v E F G H I
    17 =O5
    18 =VLOOKUP(E17,'MASTER DATA'!$C$5:$E$9,3,FALSE)
    19 =VLOOKUP(E17,'MASTER DATA'!$C$5:$F$9,4,FALSE)
    20
    21 =VLOOKUP(E17,'MASTER DATA'!$C$5:$J$9,8,FALSE)
    22 =INDEX('MASTER DATA'!$B$5:$B$9,MATCH('DISCHARGE SLIPS'!E17,'MASTER DATA'!$C$5:$C$9,0))

    For Row 20, follow same concept as in other row, however, I was not sure what columns you wished to have the data retrieved from.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    India
    MS-Off Ver
    google sheet
    Posts
    12

    Re: Vlookup to automate discharge slips

    Works. Thanks.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Vlookup to automate discharge slips

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Registered User
    Join Date
    05-08-2020
    Location
    India
    MS-Off Ver
    google sheet
    Posts
    12

    Re: Vlookup to automate discharge slips

    Yes i am new here. Thanks for informing the rules of the forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 12-27-2017, 08:32 AM
  2. Fill cells with discharge dates
    By stephenedwardbennett in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-08-2016, 09:13 AM
  3. Filling cells with discharge dates
    By stephenedwardbennett in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2016, 06:14 AM
  4. Beginner trying to calculate battery charge and discharge
    By Janusz McNeill in forum Excel General
    Replies: 4
    Last Post: 04-27-2016, 07:24 PM
  5. Moving row to a worksheet once discharge date is filled in.
    By Steveja in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-29-2013, 06:30 PM
  6. Start and Stop times by account number and discharge date
    By newbie4 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2013, 03:56 AM
  7. Mail Slips
    By Savoy12000 in forum Excel General
    Replies: 2
    Last Post: 04-06-2010, 04:12 PM

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