Index Formula Question?
 

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/

Index Formula Question?
 

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/