Return Multiple Column headers from row title and content?

Good day everyone,

Can any experts point me in the right direction... I'm looking for a solution to this, I need to bring a list of column headers based on the row contents.

If a row heading is selected, I need it to return each column header with a tick (capital P) in the intersecting cell.

I tried using =IF(VLOOKUP(CELL,DATA,COLUMN HEADER,0)="P","1.1","")&IF ......... extending this all the way through and it works but I feel there is a shorter way I'm missing.
I tried a fiddle with a couple of UDF but could never get them to work right.

Can anyone please help me with a solution to this?

I'm sorry that's not what I'm looking for I'm afraid, the table attached was just for reference.

I want to reference that data and bring back the column header for each "P" in the row.
for instance,
in a separate cell i type "HCD" and then the adjacent cell gives me the result of 1.1, 1.3, 1.4, 1.5, 2.1 and 2.3

Just a list of all the column headers from row reference?

Yeah, I think I can work with that, thank you.

UDF
Use in cell like
=GetHeaders(A2,$B$1:$I$1,B2:I2,", ")

Please Login or Register  to view this content.

Thank you for the reply Jindon, unfortunately, I can't seem to figure out this one, keeps giving me a #name error. And because i do not really understand the udf i cannot figure out why it is giving me the error.

See the attached.

Right, amazing! I'm with you! Is there a way to apply that to a separate worksheet with a data validation list to select the row title?

See the attached.
=GetHeaders(A1,Sheet1!A1:I8,", ")

Please Login or Register  to view this content.

Amazing!

Last point, why is it bring back the zero at the start?

Sorry to be a pain, but my VBA is very weak!

OOps of course,
1) Change the formula in B1 to
=IFERROR(GetHeaders(A1,Sheet1!A1:I8,"p",", "),"")

2) Change the code to

Please Login or Register  to view this content.

That is fantastic! Thank you so much, this should save a ton of time.