Match Index, one down two along, different sized lookups!

[nj2406]

Hello! I will try to explain my sheets and formulas I have tried thus far.

I am trying to populate the top row of a table using a lookup sheet of various sites.
Here is the lookup, the reason for the repeated values in column B is another INDEX/MATCH within my table (which is populating just fine). I would like my column C values to appear in a table heading row, when the A column value is selected in a drop-down menu (shall we call this cell N2).

Here is my current formula, where I have added one to the + row value to move down my list.
=INDEX(Lookup!$A$1:$C$23,MATCH($N$2,Lookup!$A$1:$A$23,0)+1,3)

HOWEVER! As you may notice some of my mini-lists in column C are shorter than the other, and I would like my formula to stop populating my header row (at the moment it goes 0 for the space, then continues to the next list).

I have tried using the 0/space in the previous header row cell, in the hope that the rest of the heading row would be zeros, but it has only done this once, so two zeros before starting from the next mini-list.
i.e
=IF(A2=0,"0",INDEX(Lookup!$A$1:$C$23,MATCH($N$2,Lookup!$A$1:$A$23,0)+1,3))

Any help would be greatly appreciated, could this require an INDIRECT to assign the mini-list array?

 

[bewsh1987]

apologies I cant see pictures

I will check on my phone

 

[nj2406]

Many thanks. I have solved this by creating a new lookup where I have transposed the Column C values next to their sppropriate Column A value, and used an Index/Match