Alrighty I have been baffled by this issue. I have tried a couple of things but have not been able to get past the to many arguments error. The currently formula is working as designed accounting for blanks in the lookup table and returning blank cells. However, I am struggling with is adding syntax that removes errors and shows blank specifically if the J6 cell is not populated

Any help would be much appreciated.

=IF(VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0))=0,"",VLOOKUP($J$6,'Release Matrix'!$B$7:$AF$15,MATCH(L5,'Release Matrix'!$B$5:$AF$5,0)))

Thank you in advance!

RG