pull data from diff sheet 2

[ksbrace]

Hello,
I have 3 sheets and they all have full name (First Last). I want to pull the amt column from sheet one and populate a column on sheet 3 based on Full Name. Any help would be greatly appreciated. Thanks in advance!

 

[SkipVought]

Hi,

Use VLOOKUP or INDEX & MATCH functions.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

Skip,
as always, I appreciate your advice. Any chance I could get a quick example? All the examples I find on the web seem to be pulling data from the same sheet. I just want to pull the amt from Source and place it in Destination. Not all names are in Destination.

Source:
Fname Lname FullName AcctNum PaidDate Amt

Destination:
Fname LName FullName AcctNum Misc Misc2 Amt

 

[SkipVought]

Assuming that you already have data in Destination!A:C and you need data in D:F....
[tt]
d2: =vlookup(c2,Source!$C:$F,column(),false)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

Skip,
Thanks, but I'm getting #N/A.

I made a test "Source", all populated.
fName lName fullName AcctNum Amt

I then made a test "Dest", only first 3 columns are populated
fName lName fullName AcctNum Amt

I put this into D2 (2nd row of AcctNum)
=vlookup(c2,Source!$C:$E,column(),false)

Any help would be great.

 

[GlennUK]

Are you sure that a matching entry exists in "Source"? ( and I mean identical, not similar, and no trailing spaces in either entry )

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Please post the first few rows of each (copy 'n' paste please), making sure that at least one row has a corresponding values in the lookup table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

Source:

firstname	lastname	FullName	ActNum	Amt
 LAKISHA	MILLER	 LAKISHA MILLER	165112334357	320.00
 ELSIE	DOLBOW	 ELSIE DOLBOW	167708079233	510.00
 BRIAN	VARDA	 BRIAN VARDA	163486659134	480.00
 DEBORAH	ALLEN	 DEBORAH ALLEN	167254567339	350.00
 STACEY	THOMAS	 STACEY THOMAS	164713085134	350.00

Dest:

firstname	lastname	NameKey	ActNum	Amt
ROBIA	COMER	ROBIA COMER		
TAMIKA	LEWIS	TAMIKA LEWIS		
LAKISHA	MILLER LAKISHA MILLER		
TAMIKA	LEWIS	TAMIKA LEWIS		
GARY	COLOTTI	GARY COLOTTI

All of the names from Dest are in Source.

 

[GlennUK]

Maybe:

=vlookup(c2,Source!$C:$E,column()-2,false)

... note the -2.





Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[ksbrace]

Glenn,
Thanks for the help, but still comes up #N/A.

 

[SkipVought]

using your example and Glenns, -2 correction, I got a hit on LAKISHA MILLER.

All other were NAs because no match in the data you posted.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

Ok, what could I possibly doing wrong. I have even recreated 2 sheets with the data that I copied pasted.

I put this in D2:

=vlookup(c2,Source!$C:$E,column()-2,false)

drag it down and all say #N/A.

any ideas?

 

[SkipVought]

Did you hit F9 to calculate? If so, your Calculation Mode is set to manual calculate.

and your source sheet is actually named Source?



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

I did not hit F9. My sheet is named Source. Any other ideas?

 

[SkipVought]

Please DO hit F9, as your application may be set to MANUAL calculation.

1) COPY your formula from the formula bar and PASTE here.

if you copy your formula from D2, it should be
[tt]
=VLOOKUP($C2,Source!$C:$F,COLUMN()-2,FALSE)
[/tt]
2) verify that both tables start in column A and have 5 columns of data.

3) verify that there are no leading or trailing spaces in column C on BOTH SHEETS.

4) if all else fails, COPY the first FULL NAME from the source sheet and FIND the corresponding value on the destination sheet using the FIND feature. PASTE that value into the destination sheet and

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ksbrace]

well, as expected, it was a stupid mistake on my part. There was a leading space on the Source. thanks everyone!