I am working with some dynamic lists and I am not sure how to handle this task. ( I would post a picture, just not sure how to. SO I am including google drive sharable link for each image)
I have a dynamic lists that is 9 across horizontally and 4 across vertically. (https://drive.google.com/open?id=1ox...LiyIzfaKcnPX5d)
The dynamic list is named "ODORIZER". (https://drive.google.com/open?id=1Kp...Fb91XemLAQY5Yy)
When I pick "ODORIZER" from the drop down menu under column "D", I want the information to populate E thru I of Row 3, then move to row 4 and populate E thru I and continue this till the information in the Dynamic list is complete.
(https://drive.google.com/open?id=121...plSxZimRIy6XlG)
I have been using VLOOKUP and HLOOKUP for a couple of other formulas, but I am not sure how to complete this.
Thanks,
Richard
Bookmarks