Returning to a Relative Starting Point

Hello,

My explanation of what I want is a bit confusing so I'm hoping someone can understand.

I am trying to create a looping vlookup macro. So in cell B1, there is a vlookup formula that will loop until the cell to the left (A1) is blank. Once completed, I would want it to move to C1 (with another vlookup formula I have entered) and loop until A1 is blank again.

Each time I run the macro, the number of data rows vary so sometimes it will have 10 sets of data, sometimes 100 sets of data. Therefore, I want it to return to the relative starting point "B1" and then move 1 cell to the right (C1) and have the second formula triggered. Also, I want to trigger the vlookup macro anywhere, for instance if I trigger it in cell D3, I would want it to loop and then go to E3. I know how to do this using absolute points but how do I get it to return to the relative starting point?

Thank you!