Forum Discussion
New to IF... THEN... formulas
I have a spreadsheet with 2 sheets. If column B of the first sheet (called Hopem) has number 10-41000, then I need the number entered in cell D14 to appear in cell D9 of the second sheet called New....
Yes, to be very clear 10-41000 will appear only once in column B of sheet Hopem but it might not always be on the same row
It could be
=IF(COUNTIF(Hopem!B:B,"10-41000"),Hopem!D14,"")