VLOOKUP Multiple Tables Value Return

A

AdExcel

Ive been working on a pricing sheet for my company, I ve used Vlookup t
search between two tables of values dependent on whether a certai
dropdown box in the table is selected - this currently works fine, bu
now I have to add two more tables and I cant seem to get it working.
dont think I ve a good enough grasp of the syntax necessary... Ive trie
Elseifs and doubling and changing the ranges to the new tables but
cant seem to work it out. Any help or suggestions? Maybe Vlookup isn
the best way to do it... File attached

+-------------------------------------------------------------------
|Filename: WIP_Pricing1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=831
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top