IF statement using formula not value

[onbeillp111]

I have an if statement,

This IF statement is comparing dates in column C and Column A. However in column C and Column A are vlookup statements so the are never equal. is there a way to make the formula look at the value in the cell and note the vlookup formula?

[Jonmo1]

Formulas do look at the value in the cell (wether it's entered by hand or the result of a formula doesn't matter)
What matters is what the result of the formula actually is.

It's llikely that the result of your vlookup isn't really a Number, but a Number stored as text.

Also, your AND statement is redundant..
If C2 is Greater than A2, then certainly it is already determined to be NOT equal to A2..
So you just need
=IF(C2>A2, "WORKS", "DOESN’T WORK")

Can you post the formulas in C2 and A2 ?

[onbeillp111]

I was incorrect when i marked this as solved

[onbeillp111]

My Mistake, it still doesnt work properly, I attached an example, if you look at the data tab, row 6 should be "doesn't work" because C2 = A2.

[Jonmo1]

You don't have a formula in column D on the Data Tab...(or in the entire book for that matter)

However, when I put this formula in D2 and fill down
=IF(C2>A2, "WORKS", "DOESN’T WORK")
It produces the correct results.

[FDibbins]

When I use Jonmo's formula on your data, I get "Doesnt work"?

	A	B	C	D	E
1	Install dated	serial_num	FAILDATE	CHECK
2	5/8/2013	607368173	5/13/2013	WORKS	WORKS
3	8/20/2013	AC726081601010	8/21/2013	WORKS	WORKS
4	8/20/2011	AC735073809716	11/20/2013	WORKS	WORKS
5	1/19/2012	AC735074100497	12/14/2012	WORKS	WORKS
6	8/10/2012	AC735074101463	8/10/2012	WORKS	DOESN’T WORK
7	9/23/2011	AC735074101555	1/25/2013	WORKS	WORKS
8	6/20/2012	AC735074106297	7/5/2012	WORKS	WORKS
9	7/1/2009	AC735074209081	5/25/2013	WORKS	WORKS
10	7/5/2013	AC735074209931	8/7/2013	WORKS	WORKS

E2=IF(C2>A2, "WORKS", "DOESN’T WORK") copied down