Use Excel as a database: how to display query results

[odelia]

Hi Everyone!

I am building an Excel file for a friend who is conducting a clinical study, to store and analyze the data.
To simplify, let's say I have two tabs. On the first tab there is a table "Patient" with characteristics of each patient (Unique ID, age, gender etc)
On the second tab I have a table "Tests" with results of clinical tests.

I would like to :

1- Connect those two tables using PatientID
2- Build for my friend an easy solution to visualize all the tests while dynamically filtering by age, gender, etc...

I have somehow completed the step 1 (I don't remember even how), but how to do the step 2?

Thank you for your help!
I use Excel 2016

 

[sheetspread]

In Power BI you could have a related function (DAX) or vlookup in standalone Excel.