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.
Can you please add an example workbook so we do not have to recreate the data?
Purfleet
I can't post actual data due to legal privacy concerns.
At some point, the formula started working. I don't know why. Thanks anyway!
you only need to post an example, mix up names and numbers?
Purfleet