I have a list of data with two columns, A=Day of the week, B=Persons Name. There are multiple instances of the day. I am trying to create a VLOOKUP on a new sheet that returns the first value initially, but then the next value as the formula is copied down. So if there are three people listed on Tuesday, the first three formulas on the new sheet would be the three people, not the first person three times.
Bookmarks