I have a workbook database set up to input up to 320 artists details for a festival. Main information is contact details, performance day and time, and selections from a shopping list of 400 products for their accommodation.
I need to pull the details for each artist onto a sheet for each stage each day. 9 stages, 4 days max 14 artists per day per stage. I have linked all the individual details by setting a allocated number based on stage/day/slot e.g. Thursday has a value of .1, main stage a value of 1, slot one a value of 10 so it gives code 11.1. And then used HLOOKUP to pull the data from the relevant column.
Issue comes when I get to the shopping list. Of the 400 items on the list they may only have 10 items, maybe 50... for each artist I have input the quantity for each item they have requested. I used a separate column to give any item cell with input a value of 1, and another column to add the values of it's value and the cells above it in the list to give a count value for items added.
Now I need to link the stage play list sheets to draw just the shopping list for each artist. I have a reference for the artist, and have the columns with quantity to do an item count so can do IF/OR option for products. What I don't know how to do is run either a VLOOKUP or an INDEX given the starting column moves around the table depending on where the info is. I have tried to simplify it by adding in the starting cell reference to then input this into a formula but don't know how to.
For example I know that cell D39 is the top left cell of the first artists shopping list. If I could add this into a =INDEX formula then I could make it work. Any help appreciated!
Raymundo
Bookmarks