flduckhunter73
New Member
- Joined
- Apr 3, 2013
- Messages
- 4
Hey there,
I am trying to use a vlookup to pull and ID for some company magazines based on a given city.
[TABLE="width: 744"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]City[/TD]
[TD]Vlookup[/TD]
[TD]Mag Name[/TD]
[TD]Mag Id[/TD]
[/TR]
[TR]
[TD]Tallahassee[/TD]
[TD]?[/TD]
[TD]HomesAndLand.com[/TD]
[TD]0088[/TD]
[/TR]
[TR]
[TD]Kelowna[/TD]
[TD][/TD]
[TD]Homes & Land of Tallahassee[/TD]
[TD]0108[/TD]
[/TR]
[TR]
[TD]Santa Cruz[/TD]
[TD][/TD]
[TD]Homes & Land of Ocean County, NJ[/TD]
[TD]0116[/TD]
[/TR]
[TR]
[TD]Calgary[/TD]
[TD][/TD]
[TD]Estates & Homes of Greater New Hampshire & Southern Maine[/TD]
[TD]0125[/TD]
[/TR]
</tbody>[/TABLE]
I tried using a VLookup =VLOOKUP(A2,C:D,2,TRUE)
The problem I am running into is that the vlookup is searching the arrays and pulling a magID, but it is pulling a magID that does not match the string, and it is pulling the same mag ID every time...
Do I need some sort of nested function to properly match the partial string?
I wasnt to look at the city (Tallahassee) check the mag name column to see if it contains tallahassee, and then if it does retrieve the mag ID for the match.
Please help!!
I am trying to use a vlookup to pull and ID for some company magazines based on a given city.
[TABLE="width: 744"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]City[/TD]
[TD]Vlookup[/TD]
[TD]Mag Name[/TD]
[TD]Mag Id[/TD]
[/TR]
[TR]
[TD]Tallahassee[/TD]
[TD]?[/TD]
[TD]HomesAndLand.com[/TD]
[TD]0088[/TD]
[/TR]
[TR]
[TD]Kelowna[/TD]
[TD][/TD]
[TD]Homes & Land of Tallahassee[/TD]
[TD]0108[/TD]
[/TR]
[TR]
[TD]Santa Cruz[/TD]
[TD][/TD]
[TD]Homes & Land of Ocean County, NJ[/TD]
[TD]0116[/TD]
[/TR]
[TR]
[TD]Calgary[/TD]
[TD][/TD]
[TD]Estates & Homes of Greater New Hampshire & Southern Maine[/TD]
[TD]0125[/TD]
[/TR]
</tbody>[/TABLE]
I tried using a VLookup =VLOOKUP(A2,C:D,2,TRUE)
The problem I am running into is that the vlookup is searching the arrays and pulling a magID, but it is pulling a magID that does not match the string, and it is pulling the same mag ID every time...
Do I need some sort of nested function to properly match the partial string?
I wasnt to look at the city (Tallahassee) check the mag name column to see if it contains tallahassee, and then if it does retrieve the mag ID for the match.
Please help!!