IF and OFFSET Combination

[Martin1984]

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