Hi,

Try this, It rerurns the 1 or 0 plus if c2 cant be found in column A 'Lookup
Not found'

=IF(ISNA(VLOOKUP(C2,A1:B6,2,FALSE)),"Lookup Not
found",(VLOOKUP(C2,A1:B6,2,FALSE)=1)*1)

Mike

"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!!!