Ideally all I really need is a function that would do this: =WHEN(Sheet1!$D$23=Sheet2!B2, DISPLAY=Sheet1!$G$36) but I couldn't find a WHEN function....