+ Reply to Thread
Results 1 to 3 of 3

combine Patient database information for reportiing

  1. #1
    Registered User
    Join Date
    11-28-2018
    Location
    Perth Australia
    MS-Off Ver
    2010
    Posts
    4

    combine Patient database information for reportiing

    hello all,

    On the "treatment" sheet I have some basic information about a patient that includes the patient registration number and the item code for the treatment they received. For the purposes of the reporting I need to maintain a separate line for each item of treatment but repeat all of the other information.

    On the 'details' sheet I have all the patients details, address etc.

    on the third sheet "combined" I have the information from "treatment" brought across into the format I need to keep it for reporting.

    I need a formula which will look up the patient number on "combined" and draw the other patient details into the sheet from the "details" sheet.

    I have attached a copy with dummy data in.

    Please help, I have tried a variety of Vlookup and match functions and I cant seem to get it to work. I would just do it manually but in my version I have some 5000 lines on the "Treatment" sheet.
    Attached Files Attached Files
    Last edited by Nate_from_Australia; 04-17-2019 at 11:37 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: combine Patient database information for reportiing

    Put this in C2 on the combined sheet and copy down:
    =INDEX(Details!G:G,MATCH(F2,Details!A:A,0))

    If that does what you need then you can use the same formula in other columns you wish to populate but change the red part to whichever column on the details sheet you wish to retrieve data from.

    Does that help?

    BSB

  3. #3
    Registered User
    Join Date
    11-28-2018
    Location
    Perth Australia
    MS-Off Ver
    2010
    Posts
    4

    Re: combine Patient database information for reportiing

    Thank you solved with a simple and effective solution.

+ 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. Merging rows, patient database
    By jcexceljc in forum Excel General
    Replies: 5
    Last Post: 09-18-2017, 04:02 PM
  2. Lookup patient information
    By declan.clune2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2016, 08:09 PM
  3. Save Patient Records As Database System
    By faiz123123 in forum Excel General
    Replies: 1
    Last Post: 09-09-2014, 10:17 PM
  4. Replies: 5
    Last Post: 07-31-2014, 12:51 PM
  5. Replies: 5
    Last Post: 11-02-2012, 03:08 AM
  6. Matching patient personal data to that already stored in a database
    By helenjwheeler in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-18-2009, 02:00 PM
  7. Replies: 2
    Last Post: 03-17-2006, 01:00 AM

Tags for this Thread

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