if "%" = yes or no

  • Thread starter Thread starter Siny-j
  • Start date Start date
S

Siny-j

Hi ppl,
ok 1st of all,
what i am trying to do is make a formula on sheet 2 that looks on sheet 1 in
column E (from row 3 to 1000 ) for a "variable" wich i got on sheet 2 -
column A/row3 to 500 and if that variable is present in sheet 1 ,that it
then in sheet 2 gives a Yes or No anwser at column B row3 to 500.

And this is what i got now:
=ALS('2003'!E$3:E$1000=$A3;"nee";"ja") Translation:
=if('2003'!E$3:E$1000=$A3;"no";"yes")

But with this formula i get a wrong answer at 4 out of 10 !?
So what am i doing wrong ??

And for a Single sheet i use this >> =ALS(D72=0;"nee";"ja")
and this works properly !

So could any1 please give me the correct formula to use this function on 2
sheets ??

Thx in advance
Siny-j
 
in each cell of sheet2 B3 tot B500
=ALS(sheet1!E3=A3;"ja";"nee")
OK ?
Gilbert
 
Siny-j

Revised version (I had the yes and no mixed up)

=IF(ISNA(MATCH($A3,'2003'!$E$3:$E$1000,0)), "yes", "no")
Possible Translation
IF -> ALS
ISNA -> No clue
MATCH -> GELIJKE

Dan E
 
Thx Dan,
that is indeed what i was looking for.
[ Dutch translation: =ALS(ISNB(VERGELIJKEN($A3;'2003'!$E$3:$E$1000;0));
"ja"; "nee") ]

J.
 
Back
Top