If Statement

[Guest]

I need help on an existing VBA formula:

In my spreadsheet “Conversion Validation Template Billable Jobs†row J3.
I want to do a vlookup on J3 that would look up the value in D3 in a
Table_Array spreadsheet “VBAP†Col_Index_Num #3 IF AND ONLY IF the value in
rows of column B is: PY.

 

[Guest]

dim mycell as range

for each mycell in range(Cells(1,2), cells(1,2).end(xldown)")

if mycell.value = "PY" then

"CODE HERE "

end if
next mycell