ExcelBanter - Vlook in VBA with If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlook in VBA with If statement (https://www.excelbanter.com/excel-discussion-misc-queries/46282-vlook-vba-if-statement.html)

Jeff

Vlook in VBA with If statement

I need help to run aVBA formula to execute the following:

Do a vlookup of the value in row €œA3€in wooksheet €œBillable Jobs€ in the
worksheet €œVBAP€ column €œD€ if and only in worksheet €œVBAP€ column C the cell
value is €œZA€
--
Regards,
Jeff

Jeff

Addional info
--
Regards,
Jeff

"Jeff" wrote:

I need help to run a VBA formula to execute the following:

Do a vlookup of the value in row €œA3€in wooksheet €œBillable Jobs€ in the
worksheet €œVBAP€ column €œA€ - to take the value in column "D" - if and only in worksheet €œVBAP€ column C the cell
value is €œZA€
--
Regards,
Jeff

All times are GMT +1. The time now is 03:37 AM.