Retrieve data based on 2 choices

I need to find a way to make Vlookup in VBA use 2 requirements.

My formula:

Please Login or Register  to view this content.

Please disregard the message box part as that is just a placeholder for something else later but it helps me determine if my code is working. This is code that I have built off of.

I have a separate sheet with data from A - AG. My code allows me to find a name I gave my values such as "ABC123" and loads the data on another sheet filling in the details. Why? It is recalling an old file we sent and adding it so I can see what was sent and I can resend it with new data.

My confusion so far has been needing to provide an option for the B column (B1) with the Version. Example: I send a form with name ABC123 and Version: 00. If I have to send a correction, I have to add 01 but the name stays the same. So basically, I will have the same PON name multiple times but VLOOKUP only finds the first one.

What I am needing is to find a way to search by PON and by Version If it could do a search and provide all the versions ahead of time, that would be great but I don't know if that is a reach for VBA. Otherwise, worst case, how can I make multiple conditions with prompts to be met for VLOOKUP in this code?

snapshot, welcome to the forum

A few observations...
1. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I will add them for you - this time )[/B]

2. Do you really need VBA for this? You could probably do it just as easily with a formula