Vlookup problems|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I'm having a problem with a vlookup formula, and maybe vlookup isn't even what I want.

I have two tables on one sheet. Table 1, named Data, has a data range A2:H85. Table 2, named Daily, has a data range K2:M70.

Table Data has column D called Name, containing county names. It also has column G called Num. Table Daily has column K called Name, also containing county names, and column L, also called Num.

The county names in Daily are a subset of county names in Data, e.g. 100 unique county names in Data and 60 in Daily.

I want to fill column G in Data with values from column K in Daily where the tables have matching county names, essentially left joining the tables. I thought that would be a vlookup formula, but what happens is that column G gets populated row by row, rather than only matching by county name. That is, if the first county name in Data is Colter, it matches the first county name in Daily, which could be something like Adams. Or, changing the formula gives me all #N/A's.

Example formula is =VLOOKUP([@NAME], K4:M71, 2, FALSE)

Any clues as to how to accomplish this? Thanks.