If Statement
 

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.

--
Regards,
Jeff

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

"Jeff" wrote:

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.

--
Regards,
Jeff