And with If statement not working

[topswim]

Below I have a formula using the AND function with my IF statement (Y35), but notice it is not performing correctly. I should of returned A35 and not ??. Trying to understand why this is not functioning correctly. Hopefully this issue will resolve my vlookup issue where, for example=vlookup(w35,A:B,{1,2},false), is only bringing back A35 instead of A35 and B35.

Y35 A35 B35 C35 w35 X35 IF(AND(X35=0,W35="N"),A35,"??")

AZGIL06E03

123

AZGIL06E03

N

0

??

 

[offthelip]

Is the zero in X35 a calculated value? if it is you could try changing your if statement to something like this:
= IF(AND(X35<0.000001,X35 >-0.000001,W35="N"),A35,"??")

 

[topswim]

Yes it is. I did try yours as well Offthelip and even replaced X35 with 0, instead of the formula and still same result.

 

[topswim]

Yes it is. I did try yours as well Offthelip and even replaced X35 with 0, instead of the formula and still same result.

I also see what I posted shifted my cell names (A,B,C,W,X and Y) back to the left. They should be spread out accordingly to the columns

 

[offthelip]

The equation works for me, so the only other possibility I can think of is: Have you got calcuation set to manual?

 

[Fluff]

Check that you don't have any leading/trailing spaces in W35

 

[topswim]

The equation works for me, so the only other possibility I can think of is: Have you got calcuation set to manual?

No, but I have even double check and click Calculate Now. Is it a possible setting in Excel that I may be missing?

 

[topswim]

Check that you don't have any leading/trailing spaces in W35

That is also a formula Fluff and had also tried replacing that with just the N

 

[Fluff]

There is nothing wrong with the formula.

+Fluff 1.xlsm
	A	B	C																				W	X	Y
34
35	AZGIL06E03	123	AZGIL06E03																				N	0	AZGIL06E03
Main

Cell Formulas
Range	Formula
Y35	Y35	=IF(AND(X35=0,W35="N"),A35,"??")

so it must be the data, assuming you are looking at the right cells.

 

[topswim]

There is nothing wrong with the formula.

+Fluff 1.xlsm
	A	B	C																				W	X	Y
34
35	AZGIL06E03	123	AZGIL06E03																				N	0	AZGIL06E03
Main

Cell Formulas
Range	Formula
Y35	Y35	=IF(AND(X35=0,W35="N"),A35,"??")

so it must be the data, assuming you are looking at the right cells.

Yes, I am looking at the correct cell. I'm just not sure what is causing this issue? I even rebooted to see if that might resolve, but no.