IF and OFFSET Combination

Hi all,
Hoping someone can help. I have scanned the forum, and while there are similar threads I can't quite figure this out on my own.
Start from cell B8 on the Creative Design&Media Tech tab, I need this to refer the data in the AppData tab, column K, and if the data matches cell reference A6 on the Creative tab, then the information is pulled through and offset, or transposed, vertically as opposed to horizontally. With each relevant heading, ie, Question 1, Question 2, etc.

The OFFSET is not the problem, its combining it with IF, or a VLOOKUP, that I am struggling with. As I will be copying this page on to the other tabs and cell A6 will change, corresponding to the name of each tab.

File attached.

Straight forward in theory, just eluding my understanding at present!


Best,

Martin

You've lost me. What do you expect to see? Where do you expect to see it?

I'm still not clear what columns C onwards of CD&MT are supposed to contain. For testing, I created a dropdown box in A6, allowing t=you to select which response you're after... and then used thisn in B8, copied down:

=INDEX(AppData!$A$2:$AB$4,MATCH($A$6,AppData!$K$2:$K$4,0),ROWS($1:1))

Still not clear. Are you saying that there will be several rows in column K called CD&MT and you want all such rows pulled into the CD&MT sheet? If so, a different approach is needed.

Finally... I think we're there.

=IFERROR(INDEX(AppData!$A:$AB,AGGREGATE(15,6,ROW(AppData!$K$2:$K$200)/(AppData!$K$2:$K$200=$A$6),COLUMNS($B:B)),ROWS($1:1)),"")

I really would question the necessity for multiple sheets, however. You will merely increase the file size for no material advantage.

Then simply remove the data validation from a6 and make it static... and don't blame me if the file gets big!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.