Let's assume that i'm healthcare giver to patients of many companies
Each group of these companies has its own price list let them be for example (petrol comp. , Schools , industrial factories , banks)
In the main sheet i have the names of patients and the company they belong to
I'd like excel to recognize the compnay and automatically search in the corresponding price list sheet and lookupfor the medica procedure performed to the patient for fees