Hello,
I'm not sure how to ask the question to my problem, hopefully, my question makes sense: I am using Excel 2016.
In Worksheet A, cell A1 = $1,000, cell A2 = $1,000, cell A3 = $1,000.
In Worksheet B, cell A1 needs to equal if cell B1 = X then worksheetA1 and/or C1 = X then worksheetA2 and/or D1 = X then worksheetA3.
I'm not sure how to ask the question to my problem, hopefully, my question makes sense: I am using Excel 2016.
In Worksheet A, cell A1 = $1,000, cell A2 = $1,000, cell A3 = $1,000.
In Worksheet B, cell A1 needs to equal if cell B1 = X then worksheetA1 and/or C1 = X then worksheetA2 and/or D1 = X then worksheetA3.