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.
Bookmarks