Lookup from a table with multiple criteria

hi guys i need some help with VLOOKUP, actually i am not sure if VLOOKUP can achieve what i am trying to do, so I hope some1 can help me out!

vlookup2.png

see picture above. basically what i am trying to do is:

When I select a quantity and object on the dropbownlists i get a value back from the brown marked area. Is this possible?

thank you for your time and help!

Welcome to the forum, Londoner. Take a moment to read the Forum Rules, link is above in the menu bar. You've managed to tweak several things in your first post.

1) Title should reflect the issue only, not guess at an answer
2) post workbooks to aid helpers, not pictures forcing them to recreate it

Click GO ADVANCED on your next post and use the paperclip icon to post up a copy of your workbook.

I've changed your title, this time.

I've adjusted your layout to provide two simple to use lookup tables. The second table gives the added benefit of serving as the Drop Down source (Data Validation) for the "Item" in the form section off to the right.

The magic is in the M column. A standard INDEX/MATCH/MATCH formula, but a VLOOKUP uses the second table to determine which category the item goes in and feeds that to the second MATCH function.

=INDEX($B$3:$E$10, MATCH(K4, $A$3:$A$10, 1), MATCH(VLOOKUP(L4,$G:$H, 2, 0), $B$2:$E$2, 0))