Hi,
I have my existing formula like the below,
=(INDEX(INDIRECT(O29&"A"),XMATCH(D29,INDIRECT(O29&"H"),1 ),XMATCH(C29,INDIRECT(O29&"W"),1 )))
Let say I have text in cell O29 is FSD & I will have Q28 cell as either H or V. If it is H, I wanted INDIRECT to create reference like FSDHA.
I'm not sure how to add that Q28 cell reference in INDIRECT after O29. Please assist.
I have my existing formula like the below,
=(INDEX(INDIRECT(O29&"A"),XMATCH(D29,INDIRECT(O29&"H"),1 ),XMATCH(C29,INDIRECT(O29&"W"),1 )))
Let say I have text in cell O29 is FSD & I will have Q28 cell as either H or V. If it is H, I wanted INDIRECT to create reference like FSDHA.
I'm not sure how to add that Q28 cell reference in INDIRECT after O29. Please assist.