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 (nonessential for the answer) 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.

Excel 2007/Windows XP

	A	B	C	D	E	F	G	H	I	J	K
1	Application Name	Application ID	First Name	Last Name	Username	Req	PO	Receive	Invoice	Approve	Account Group
2	App1	1	John1	Doe1	jdoe1	W	W	W	W	N/A	Marketing
3	App1	1	John2	Doe2	jdoe2	W	R	W	R	N/A	Store display
4	App1	1	John3	Doe3	jdoe3	N/A	N/A	N/A	N/A	W	IS and GP
5	App1	1	John4	Doe4	jdoe4	W	R	W	R	N/A	IS
6	App1	1	John5	Doe5	jdoe5	W	W	W	W	N/A	Gradus
7	App1	1	John6	Doe6	jdoe6	W	R	W	R	N/A	All
8	App1	1	John7	Doe7	jdoe7	N/A	N/A	N/A	N/A	W	Store Ops
9	App1	1	John8	Doe8	jdoe8	R	R	W	R	N/A	IS
10	App1	1	John9	Doe9	jdoe9	R	R	W	R	N/A	IS and GP
11	App1	1	John10	Doe10	jdoe10	R	R	W	R	N/A	Marketing
12	App1	1	John11	Doe11	jdoe11	W	W	W	W	N/A	IS and GP
13	App1	1	John12	Doe12	jdoe12	N/A	N/A	N/A	N/A	W	IS
14	App1	1	John13	Doe13	jdoe13	N/A	N/A	N/A	N/A	W	Legal
15	App1	1	John14	Doe14	jdoe14	R	R	W	W	N/A	All

<tbody>
</tbody>

Sheet1​

Excel 2007

	A	B	C	D
1	Application ID	Application Name	Option ID	Option Value
23	1	App1	19	Advertising
24	1	App1	3	N/A
25	1	App1	2	W
26	1	App1	1	R
27	2	App2	43	View, Update
28	2	App2	42	View, Add, Update, Delete, Copy
29	2	App2	41	View

<tbody>
</tbody>

Sheet2​

Thank you for your time.

P.S. Cross-posted last week at Validate Cells Against 2 Values In Different Sheet Via VBS