VBA - IF statement based on VLOOKUP

[SORD]

I am trying to automate my first VBA macro. It is the printing of the current sheet (SHEET2) based on a VLOOKUP value on another sheet (SHEET1). If the value is 0 then move to the next record on SHEET1 until no more records. I can perform the lookup no problem but then I am having trouble formatting the IF statement.
SHEET2 is an empty form that would be populated with data calculated based on the returned value from SHEET1
Can anyone assist me?

 

[6StringJazzer]

You need to provide the details about what is the VLOOKUP you want to do.

Also, it might be better to use the built-in VBA Find method instead of a worksheet function to do what you want to do. We need to understand your objective, not how you are expecting that it would be done.

What is the value on Sheet2 that you want to look for?
What is the range on Sheet1 where you want to look for it?
What is the corresponding range on Sheet1 that you want the retrieve the resulting value from?

Please show your existing VBA code so we can show where where to update it. I recommend pasting the code into your post, selecting it, then clicking the "VBA" button to add code tags.

 

[SORD]

Thank You
I have reworked this and will re-post the question with better documentation