dvspnutCopper ContributorFeb 21, 2020Excel Formula I want a formula that will display a yes or a no if certain data is present on a separate page I.e. I want it to see if it can find 42 on sheet 1 in column 1 and then say yes or no The workb...Show MoreSAVANNAH Allocations Upload me.xlsx59 KB
SergeiBaklanDiamond ContributorFeb 21, 2020dvspnut That could be like =IF(COUNTIF('5 Boards'!A:A,$A2),"yes","no")SAVANNAH Allocations Upload me.xlsx63 KB
