Lookup value in multiple sheets


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



Upload some sample files and we can give you a formula or at least better guidance since it seems like a macro will have to be used in this case.
don (rep: 1715) Aug 26, '16 at 1:05 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login