Results 1 to 5 of 5

Looking up lab codes: Returning specific cell value based on combination of TRUE cells

Threaded View

katertot Looking up lab codes:... 09-06-2021, 12:14 PM
Greg M Re: Looking up lab codes:... 09-06-2021, 12:55 PM
katertot Re: Looking up lab codes:... 09-06-2021, 01:03 PM
Greg M Re: Looking up lab codes:... 09-06-2021, 01:22 PM
Bo_Ry Re: Looking up lab codes:... 09-06-2021, 01:57 PM
  1. #1
    Registered User
    Join Date
    12-17-2020
    Location
    Maryland
    MS-Off Ver
    360
    Posts
    4

    Question Looking up lab codes: Returning specific cell value based on combination of TRUE cells

    I work in a small medical clinic and manually looking up lab codes is a time sink for my team.

    I'm attempting to make an excel lookup tool for finding the correct lab test code based on the required components. There are several components that can be ordered in any combination and each combination has a specific code. Some component examples are Chemistry, Thyroid Screen, Fecal Analysis, Urinalysis, and UPC Ratio. I'm using linked checkboxes (form controls).

    Example of the functionality I'm aiming for:

    If Chemistry and Thyroid Screen and true, then display code 105.
    If Thyroid Screen and Urinalysis and UPC Ratio are true, then display code 115.

    Honestly, all I have so far are my checkboxes linked to their respective cells and a reference table of components per code. I've been doing some research, youtubing, etc, but I'm stuck staring at the screen just totally unsure where to start with the multiple logic functions

    Workbook example attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-16-2019, 12:35 PM
  2. [SOLVED] searching combination of 2 cells based on a value of 1 cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2018, 11:10 PM
  3. [SOLVED] Returning a specific value based on one value in a range of cells.
    By stevensimon10482 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-03-2017, 08:15 PM
  4. sort all white fill cell on column I based on cell value specific txt if (true)
    By raijinlee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2017, 01:57 AM
  5. Replies: 10
    Last Post: 01-26-2015, 11:03 AM
  6. Replies: 3
    Last Post: 11-06-2014, 01:00 PM
  7. Enter value in cell based on value combination of two other cells
    By jobell in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 10:40 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