Michael,

I'm not sure what your question is, nor why the INDEX function
might be involved. You can get the formula to take values from
Sheet2 by changing the formula to

=IF(COUNT(ISODD(Sheet2!C151)),ISODD(Sheet2!D151),I SODD(Sheet2!E15
1))=3,1,0)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Michael168" wrote in
message ...

In worksheet2 cell A151, I would like to have below
=IF(COUNT(ISODD(C151)),ISODD(D151),ISODD(E151))=3 ,1,0)

How do I add in the INDEX formula so that it can refer to the
cells of
worksheet1?

Thanks for helping.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/