If Cell in column = "Y" then with offset (0, 1).value match to sheet range A3:A return ...

You may not need a macro for this. The standard functions may work just fine (ie =Lookup, =If, etc). If you are determined to do this through vba it is probably possible but I would ask that you attach a copy of your workbook so that we can be more efficient with our time.

I'm certain you are right, but the reason I thought VBA, was due to the Web Queries, Not
For All the Info on the Master Sheet, that will be pulled using an API, (still waiting
for my license number to go through), figured a Macro would Just Fall into place with
the rest.

I placed notes to correspond to what I was trying to accomplish.. you can see where I
selected A man apart, and filled in the data I would pull when I have everything in place.

Attachment:
Movies.xlsm

So after a little bit of taring down a recorded Macro, i came up with a working solution to my question

Please Login or Register  to view this content.

its not pretty but works well enough for my desired results