Need Help With Formula Please
On Wed, 1 Apr 2009 11:30:04 -0700, Langway
wrote:
Ok, I think I have a tricky one.
A B C
101 1 100
102 0 101
104 0 102
105 1 103
109 1 104
110 0 105
I'm trying to put a formula in column D that will tell me...
If C2 is found anywhere in Column A AND on the same the same row in column B
there is a 1, then 1, if not 0.
Thanks in advance for your help!!!
Excel 2007+:
=IFERROR(INDEX($B$2:$B$7,MATCH(C2,$A$2:$A$7,0)),0)
Prior versions:
=IF(ISNA(MATCH(C2,$A$2:$A$7,0)),0,INDEX($B$2:$B$7, MATCH(C2,$A$2:$A$7,0)))
--ron
|