VLookUp used in cinjunction with Concentrate

[6two6rob]

I'm currently trying to add a value (age) from one spreadsheet with first name, last name, and age to another spreadsheet with only first name and last name.

So what I've done is use the CONCENTRATE command to combine first and last name together in a new column on both tables, creating a unique identifier for VLOOKUP to use.

The problem is, no matter what I do, VLOOKUP seems to always give the wrong values.

Any insight to this? Both tables are sorted by date, ascending order, and I have TRUE as the last variable on VLOOLUP.

 

[Aladin Akyurek]

Would you post the formula as is that you have?

 

[Jonmo1]

and I have TRUE as the last variable on VLOOLUP.

Best guess is that you should change that to FALSE.

 

[6two6rob]

Here is the formula for my VLOOKUP.
=VLOOKUP(P4,'P:\Backups\CAPTA\[mods_021916.xlsx]mods_021916'!$A$2:$G$5073,2,FALSE)

Since both tables are actually not organized or similar (one table has more records than the other), I have the last value of VLOOKUP set to false.

 

[Jonmo1]

So P4 is a Concatenate formula, combining first and last names.
That formula would require column A on the other book/sheet to be the same concatenate result of first and last names.

 

[Aladin Akyurek]

Here is the formula for my VLOOKUP.
=VLOOKUP(P4,'P:\Backups\CAPTA\[mods_021916.xlsx]mods_021916'!$A$2:$G$5073,2,FALSE)

Since both tables are actually not organized or similar (one table has more records than the other), I have the last value of VLOOKUP set to false.

Would you post the value of A2 from mods...?

 

[6two6rob]

Would you post the value of A2 from mods...?

[TABLE="width: 216"]
<colgroup><col></colgroup><tbody>[TR]
[TD]RichardGrimes[/TD]
[/TR]
[TR]
[TD]DaleGordon[/TD]
[/TR]
[TR]
[TD]KatieHerrington[/TD]
[/TR]
[TR]
[TD]SheilaFenoff[/TD]
[/TR]
[TR]
[TD]JillWeber[/TD]
[/TR]
[TR]
[TD]RonaldGoodwin[/TD]
[/TR]
[TR]
[TD]RogerVincent[/TD]
[/TR]
[TR]
[TD]LynnHeuer[/TD]
[/TR]
[TR]
[TD]MelvinGray[/TD]
[/TR]
[TR]
[TD]JeffreyHarrison[/TD]
[/TR]
[TR]
[TD]AbigailGutierrez[/TD]
[/TR]
[TR]
[TD]RonaldHallam[/TD]
[/TR]
[TR]
[TD]LauraHanley Powell[/TD]
[/TR]
[TR]
[TD]MariaGreaney[/TD]
[/TR]
[TR]
[TD]SusanHoang[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

[TABLE="width: 216"]
<tbody>[TR]
[TD]RichardGrimes[/TD]
[/TR]
[TR]
[TD]DaleGordon[/TD]
[/TR]
[TR]
[TD]KatieHerrington[/TD]
[/TR]
[TR]
[TD]SheilaFenoff[/TD]
[/TR]
[TR]
[TD]JillWeber[/TD]
[/TR]
[TR]
[TD]RonaldGoodwin[/TD]
[/TR]
[TR]
[TD]RogerVincent[/TD]
[/TR]
[TR]
[TD]LynnHeuer[/TD]
[/TR]
[TR]
[TD]MelvinGray[/TD]
[/TR]
[TR]
[TD]JeffreyHarrison[/TD]
[/TR]
[TR]
[TD]AbigailGutierrez[/TD]
[/TR]
[TR]
[TD]RonaldHallam[/TD]
[/TR]
[TR]
[TD]LauraHanley Powell[/TD]
[/TR]
[TR]
[TD]MariaGreaney[/TD]
[/TR]
[TR]
[TD]SusanHoang[/TD]
[/TR]
</tbody>[/TABLE]

What result does the following diagnostic formula yield?

=SUMPRODUCT(('P:\Backups\CAPTA\[mods_021916.xlsx]mods_021916'!$A$2:$A$5073=P4)+0)