Hi All,
I am after VBA code that will basically lookup a variable range of values in reference to 3 separate data validation lists. The tricky part is that I want the results of each lookup under each other the with no row gaps regardless of how many results the reference gives. Confused? I hope this makes sense to someone because this will be a great help if it can be done! Please see attached spreadsheet.
As an example I have populated the lists with:
Product Range 1
Product Range 2
Product Range 3
The lookup values for these groups found on the ‘Ranges’ sheet are:
12151632
12071779 12071882
12097730 12071890
So the end result on the 'Promo' sheet from A3 down when these product ranges are selected in the 3 lists will be the below sequence:
12151632
12071779
12071882
12097730
12071890
Appreciate any assistance.
Bookmarks