Formula problem

  • Thread starter Thread starter Mark1ace1
  • Start date Start date
M

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
 
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"
)
 
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
 
Back
Top