IF formula , with item found on another sheet
I am trying to create a formula. i want to return a patient's status based on if that patient is found on another sheet.
I have 2 sheets
- list of active patients
- available cases 7.6
I have a an admission ID on both sheets which can be used in a vlookup type of formula.
if the admission ID is found on the "available cases 7.6" sheet, it should return a status of "Case is open" on the list of active patients sheet in the column of "Available cases". if the admission ID is not found on the available cases 7.6 sheet, it should return a status of "Filled" on the list of active patients sheet in the column of "Available cases".
im attaching screenshots of both sheets
thank you for ur help
Help Article Resources
Check out the Formula Handbook template!