re- text missing

  • Thread starter Thread starter Jerie
  • Start date Start date
J

Jerie

In sheet1 I have the word farm in cells B2,B10,B18. I need
to use that word in sheet2 cell D1, but if cell B2 is
blank I get a blank cell for sheet2 D1,how can I get the
word farm from cell B10 or B18 to sheet2 D1

Thanks Jerie
 
Hi
and what should happen if nonen of these cells contain the word farm?
You could try for example:
=IF(SUMPRODUCT(--('sheet1'!B2:B18="farm"),--(MOD(ROW('sheet1'!B2:B18)-2
,8)=0)),"farm","farm not found")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Missing 1
RE- Text Missing 2
match and display 5
Cell highlighting question 4
Payment calculation 1
Countif and sumif combination problem 2
another sumproduct with #value error... 5
Adding Inventory with items on order 2

Back
Top