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

mulitple lookups

0

Hello everyone, i'm having a problem trying do muplitple lookups, i will add a spread sheet to see what im having the issue with. I want when i select my color drop down menu it would show my quantity just as when i select my size drop down menu it show me the  quantity in the same cell.

=VLOOKUP(A7,DATA!F13:K15,HLOOKUP(INVENTORY!E7,DATA!F11:K12,2,0),0)

Answer
Discuss

Answers

0
Selected Answer

You made your template in a way that this is impossible. You need to follow my template format that I included in the attached file in your previous question. The way that I did it looks silly but it's the best way to store this kind of data when you need to sift through it later.

Once you use the setup from my template, these formulas will be a lot more straightforward.

Discuss

Discussion

that would be alot to do it your way to have it automated, i have over 30 colors or more
phoneguy (rep: 8) Mar 14, '17 at 11:39 am
It is a lot of work but that is the only way to record how many of each color you have; you have to have an entry for each variation; otherwise, you won't be able to run very useful functions and formulas on the stored data and it will be a lot more difficult to update and maintain the data. They method I gave you, though tedious to start, is how you should do it if you want to have accurate data and be able to run formulas and functions on that data. That's how it's done in a regular database as well.
don (rep: 1989) Mar 14, '17 at 11:24 pm
Add to Discussion


Answer the Question

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