Hi There,
I'm fairly new to the more advanced functions of excel and I'm struggling to find a way of doing multiple criteria lookups and then concatenating multiple results into one cell and I'm hoping that one of Ladies and Gents on the forum may be able to help.
I am trying to create a spreadsheet to display a schedule of various computers that need restarting or updating regularly. I have attached a copy of the spreadsheet I am basing this on. The first worksheet has a schedule of 4 weeks with weekdays. The second worksheet is a table of each computer and the week number and days that it restarts.
I am trying to take the week and day in the Schedule sheet and then lookup from the Servers worksheet and return the values for every server that contains that week number and that day and enter them into the cell in a soft returned list.
So for example Week one Monday. Cell B3 would lookup B2 (Monday) and A9 (1) then it would look at the table in the next worksheet and would return Server1 and Server4 as they both have 1 in the Week and Monday in the Day.
I looked at using index but I struggled with the formula.
I would greatly appreciate any insight that anyone can give on this.
Many thanks in advance,
Phill
TMW
Bookmarks