Nov 07 2018 05:28 AM
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.
I tried various combination but keep getting an error
My latest try was =IF(Hopem!B:B,"10-41000','Hopem!D14,""") but did not work
Any help would be greatly appreciated
Thanks
Jeannie
Nov 07 2018 06:45 AM
Hi Jeanne,
Do you mean if in ANY cell of the column B you have "10-41000" then formula shall return the value from the cell D14 of the first sheet into cell D9 of the second sheet?
Nov 07 2018 07:06 AM
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
Nov 07 2018 07:21 AM
It could be
=IF(COUNTIF(Hopem!B:B,"10-41000"),Hopem!D14,"")