formula doesn't work...help!

[ccarruth]

This is such a wonderful forum, has helped in past, this should be an easy one.

Have series of cells and vlookup functions in an IF(AND( layout but it doesn't work. Formula is:
'=IF(AND(C8="N",TODAY()=I8,F8>(X8+VLOOKUP(C8,'FlagTable'!$A$2:$C$3,3),"true","false")

So if all are TRUE then entire formula evaluates TRUE, if one condition is off then evaluates FALSE. I'm missing a parenthesis or comma somewhere.

The goal is to find where:
C8 has "N" in it
Today is equal to a cell value
F8 is greater than the sum of (X8 + value in a lookup table based on value in C8

 

[Hui]

The formula should be
=IF(AND(C8="N",TODAY()=I8,F8>(X8+VLOOKUP(C8,'FlagTable'!$A$2:$C$3,3))),"true","false")

I would be checking this part
F8>(X8+VLOOKUP(C8,'FlagTable'!$A$2:$C$3,3))

Edit the formula with F2
Select that part using arrows and Shift and more arrows
then press F9
Excel will show you what it evaluates to

Also check that the Value in I8 is a date, not text

If that isn't clear please post the sample file here

By the way If you only want a True/False response simply use

=AND(C8="N",TODAY()=I8,F8>(X8+VLOOKUP(C8,'FlagTable'!$A$2:$C$3,3)))

 

[ccarruth]

Thanks but couldn't find the error..attached. Is extract so references are tied to row 2 versus previous version.

 

[NARAYANK991]

Hi ,

This formula evaluates to FALSE because the second and third conditions are not satisfied.

=IF(AND(C2="N",TODAY()>(T2+VLOOKUP(C2,'Flag Table'!$A$2:$C$3,2)),F2>(X2+VLOOKUP(C2,'Flag Table'!$A$2:$C$3,3))),TRUE,FALSE)

Narayan

 

[ccarruth]

guys, I got it done..thks..