Formula problem

[Mark1ace1]

=IF(OR(G9:G64="R15",Rating="R18"),IF(DATE(YEAR(TODAY())-18,MONTH(TODAY()),DAY(TODAY()))<VLOOKUP(J9,Customers!A2:C100,2,FALSE),"OK","REJECT"),"OK")

I have the above formula in sheet1 column K...I want it to check Colum
G9:G64 with J9:J64 Customers name, against a persons date of birth i
Customers!(Sheet3 - Customers in Column B2:B10, Date of birth in colum
C2:C14) and either return "OK" or "Reject" if under 18 or 15..I jus
keep getting an OK and it is frustrating...

Mar

 

[Don Guillett]

try this. modify to suit where f2:g4 is your names and dob columns, f2 has
the dates of birth, f1 is the name desired.
=IF(DATEDIF(INDEX(F2:G4,MATCH(F1,F2:F4),2),TODAY(),"Y")<18,"dothis","dothat"
)

 

[CLR]

Sounds like part of your formula might not be working............take it
apart and check the pieces...........try just
=IF(DATE(YEAR(TODAY())-18,MONTH(TODAY()),DAY(TODAY()))<VLOOKUP(J9,Customers!
A2:C100,2,FALSE),"OK","REJECT") by itself..........then try the wrap around
IF/OR with just a simple A1+B1 middle........like
=IF(OR(G9:G64="R15",Rating="R18"),A1+B1,"OK")
.............then fix whichever part don't work..........

hth
Vaya con Dios,
Chuck, CABGx3