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
+-------------------------------------------------------------------
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
+-------------------------------------------------------------------