Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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