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
Application Name	Application ID	First Name	Last Name	Username	Req	PO	Receive	Invoice	Approve	Account Group
App1	John1	Doe1	jdoe1	W	W	W	W	N/A	Marketing
App1	John2	Doe2	jdoe2	W	R	W	R	N/A	Store display
App1	John3	Doe3	jdoe3	N/A	N/A	N/A	N/A	W	IS and GP
App1	John4	Doe4	jdoe4	W	R	W	R	N/A	IS
App1	John5	Doe5	jdoe5	W	W	W	W	N/A	Gradus
App1	John6	Doe6	jdoe6	W	R	W	R	N/A	All
App1	John7	Doe7	jdoe7	N/A	N/A	N/A	N/A	W	Store Ops
App1	John8	Doe8	jdoe8	R	R	W	R	N/A	IS
App1	John9	Doe9	jdoe9	R	R	W	R	N/A	IS and GP
App1	John10	Doe10	jdoe10	R	R	W	R	N/A	Marketing
App1	John11	Doe11	jdoe11	W	W	W	W	N/A	IS and GP
App1	John12	Doe12	jdoe12	N/A	N/A	N/A	N/A	W	IS
App1	John13	Doe13	jdoe13	N/A	N/A	N/A	N/A	W	Legal
App1	John14	Doe14	jdoe14	R	R	W	W	N/A	All

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]1[/TD]

</tbody>

Sheet1​

Excel 2007

	A	B	C	D
Application ID	Application Name	Option ID	Option Value
App1	Advertising
App1	N/A
App1	W
App1	R
App2	View, Update
App2	View, Add, Update, Delete, Copy
App2	View

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]19[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]43[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]42[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]41[/TD]

</tbody>

Sheet2​

Thank you for your time.

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