I have two different Sheets in a Workbook. I am trying to write a condition where if cell B1 Sheet 2 = cell A2 Sheet 1, and cell B2 Sheet 2 = cell B2 sheet 1, and cell A3 sheet 2 = cell C2 sheet 1, then cell B3 sheet 2 would display the text from cell D2 sheet 1. How would this be written? I have been unable to make it work. I have access to newer versions of Excel if needed.
Bookmarks