New to IF... THEN... formulas

Jeanne Cote
New Contributor

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



3 Replies

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?

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



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies