I have this formula, which does exactly what I want it to, but in a primative way. It searches for numbers that correspond to another sheet, and pulls out corresponding tag names. However it completes row by row.
I would like this formula to automatically repeat itself, for the amount of times that the number is present in the othre sheet.
E.g. In one sheet I have a column of 1, 2 & 3's. The formula searches (from a second sheet) and brings up tag names corresponding to every number 1 present. I want this formula to repeat for the amount of 1's there are. Bearing in mind, this amount could change.
At the same time, it needs to look through different rows: ROW('Compliation 1600 Daily'!1:1),ROW('Compliation 1600 Daily'!2:2),ROW('Compliation 1600 Daily'!3:3). I would also like it to do this automatically.
=INDEX('Compliation 1600 Daily'!G3:G243, SMALL(IF(1='Compliation 1600 Daily'!F3:F243, ROW('Compliation 1600 Daily'!F3:F243)-ROW('Compliation 1600 Daily'!F3)+1),ROW('Compliation 1600 Daily'!1:1)))
I would like this formula to automatically repeat itself, for the amount of times that the number is present in the othre sheet.
E.g. In one sheet I have a column of 1, 2 & 3's. The formula searches (from a second sheet) and brings up tag names corresponding to every number 1 present. I want this formula to repeat for the amount of 1's there are. Bearing in mind, this amount could change.
At the same time, it needs to look through different rows: ROW('Compliation 1600 Daily'!1:1),ROW('Compliation 1600 Daily'!2:2),ROW('Compliation 1600 Daily'!3:3). I would also like it to do this automatically.
=INDEX('Compliation 1600 Daily'!G3:G243, SMALL(IF(1='Compliation 1600 Daily'!F3:F243, ROW('Compliation 1600 Daily'!F3:F243)-ROW('Compliation 1600 Daily'!F3)+1),ROW('Compliation 1600 Daily'!1:1)))
