I have 2 files:
1 - I have to look up the value of row C3 - to populate row D3 in file
Workbook(Billable Jobs)Sheet(Header-Partners)- in file VBAP row D3 if and
only if C3 in file VBAP is: SP
2 I have to look up the value of C3 - to populate row J3 in file
Workbook(Billable Jobs)Sheet(Header-Partners)- in file VBAP row D3 if and
only if C3 in file VBAP is: PY


File Workbook(Billable Jobs)Sheet(Header-Partners)
C D J
10000000
10000001

File VBPA
A B C D
10000000 0 SP 10000073
10000000 0 BP 10000073
10000000 0 PY 30000031
10000000 0 SH 10000073
10000000 0 ZA
10000000 0 ZD
10000000 0 ZP
10000000 0 ZU 30000031
10000000 0 ZV 30000031
10000000 0 ZW 10000073
10000000 0 ZX 20000002
10000000 0 ZY 20000001
10000000 0 ZZ 20000000
10000000 10 ZC
10000000 20 ZC
10000001 0 SP 10000073
10000001 0 BP 10000073
10000001 0 PY 30000031
10000001 0 SH 10000073
10000001 0 ZA
10000001 0 ZD
10000001 0 ZP
10000001 0 ZU 30000031
10000001 0 ZV 30000031
10000001 0 ZW 10000073
10000001 0 ZX 20000002
10000001 0 ZY 20000001
10000001 0 ZZ 20000000
10000001 10 ZC
10000001 20 ZC

Regards,
Jeff