I need some VBA help in Excel - I have been using IF commands but now outgrown them!
Based on my 'sheet 1' selection from a drop down list, cell D5 in 'sheet 2' will be populated by data from 'sheet 3'.
Here is what I tried to do using an IF command however it exceeds the maximum number of nested commands. This worked fine before the limit was exceeded.
(IF(Overview!$AQ$17=1,'Excel 10'!D5,(IF(Overview!$AQ$17=2,'133-10'!D5,(IF(Overview!$AQ$17=3,'E-3120'!D5,(IF(Overview!$AQ$17=4,'NW100'!D5,(IF(Overview!$AQ$17=5,'V-27'!D5,(IF(Overview!$AQ$17=6,'GEV MP C 250 (30m)'!D5,(IF(Overview!$AQ$17=7,'GEV MP C 250 (32m)'!D5,(IF(Overview!$AQ$17=8,'GEV MP C 275 (30m)'!D5,(IF(Overview!$AQ$17=9,'GEV MP C 275 (32m)'!D5,(IF(Overview!$AQ$17=10,'EV-47'!D5,(IF(Overview!$AQ$17=11,'G52-500 (52m)'!D5,(IF(Overview!$AQ$17=12,'G52-500 (58m)'!D5,(IF(Overview!$AQ$17=13,'G52-850 (52m)'!D5,(IF(Overview!$AQ$17=14,'G52-850 (58m)'!D5,(IF(Overview!$AQ$17=15,'AW 70 1500'!D5,(IF(Overview!$AQ$17=16,'AW 77 1500'!D5,(IF(Overview!$AQ$17=17,AW 82 1500'!D5,0)))))))))))))))))
Would there also be the ability to automatically add a new product to the code if more were to be tagged on? With the IF commands I had to manually go in and add the extra data. I assume so if it is a lookup or a match function of some sorts.
Any help greatly appreciated!
Bookmarks