VLOOKUP Multiple Tables Value Return
 

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