Validate Cells Against 2 Values In Different Sheet Via VBS

[slewitan]

Hi,
I need to validate sheet1 against sheet2 that the values in columns sheet1 F-G will match sheet2 D and shhet1 B will match sheet2 A.
Basically I'm trying to recreate something similar to: {=INDEX(Sheet2!$C:$C,MATCH(1,IF(Sheet2!$A:$A=$B2,IF(Sheet2!$D:$D=F2,1)),0))} (I'm not using this b/c it would make the spreadsheet difficult for the end-user to use.)

Other Details:
1. Non-Valid: Red
2. Valid: White
3. Validation should (if possible) be case insensitive
4. Sheet1's validation will always start in F but different applications will vary in columns length.
5. Sheet2's list is connected to a refreshing data connection and will grow over time.

example.xlsx

Thank you for your time.

[slewitan]

By the way the "other details" I can handle myself, so if some can just answer the main question I would greatly appreciate it.

Thanks again.