#MULTIVALUE issue - Formula help reviewing content in cross table

we’re attempting to create a variable which will act as an indicator to look for a specfic value (e.g. “Y”) in specific column(s) in a cross table.

we’re looking for either a multiple IF function in one variable or separate variables with one IF is fine, we’re just unable to comprehend what the syntax would be to state which columns to look at rather than what it’s currently doing, which is looking at all the cells in the cross-tab and returning a #MULTIVALUE

Can you provide more details (e.g. variable formulas, screen shots) of what you have tried?