VB to loop through whole columns

I am new to VB scripting and i am required to use VB to loop through the whole column in excel to label each row.
Need to get some help on this.

I have the following 2 tables:
Untitled.jpg

The condition is that i need to look and compare each row of the 2nd table (the X and Y value) with the X and Y values in the first table.
I will name the X and Y in table 1 as X1 and Y1 and X2 and Y2 for table 2.
The idea of it is to compare and assign the lower limit of the name to the rows in table 2.

Anybody got hints on how this can be done?

Thanks for the response.

This can only work if X column is taken into the comparison.
But there might be instances where the following records are observed:

Table1:

Name X Y
----------------------
E 1 12
F 2 19


Table2:

No X Y To be populated
------------------------------------------
4 1 12.4 E
5 2 19.8 F


Hence using the index matching method will return A and B for records 4 and 5 respectively.
How can i consider both the X and Y variables when doing the comparison?