Forum

Notifications
Clear all

Vlookup problems

4 Posts
2 Users
0 Reactions
61 Views
(@el-jefe)
Posts: 2
New Member
Topic starter
 

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.

 
Posted : 08/04/2020 11:13 am
(@purfleet)
Posts: 412
Reputable Member
 

Can you please add an example workbook so we do not have to recreate the data?

Purfleet

 
Posted : 08/04/2020 4:11 pm
(@el-jefe)
Posts: 2
New Member
Topic starter
 

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!

 
Posted : 09/04/2020 7:54 am
(@purfleet)
Posts: 412
Reputable Member
 

you only need to post an example, mix up names and numbers?

Purfleet

 
Posted : 09/04/2020 3:45 pm
Share: