Lookup Text and Receive Other Text in Return

[klmiura]

I have two worksheets and I am trying to location Referrals that are in one
worksheet and match a Marketer based upon the other worksheet

Worksheet 1:
REFERRAL MARKETER NAME
Blue Cross Blue (I want the information to fill in here)
Aetna
Happy

Worksheet 2:
REFERRAL MARKETER NAME
Blue Cross Blue Jimmy Hendrix (This is the
information I want to go to the next page above based on the referral)

Aetna Jim Morrison




Worksheet 2:

 

[Eva]

Assuming that REFERRAL is in column A sheet1 and both columns (refferral and
MARKETER NAME in columns A, B sheet2) :
VLOOKUP(A1,Sheet1!A:B,2,FALSE)
Copy this formula to MARKETER NAME column

-- .
Click yes if it helped.

Greatly appreciated
Eva

 

[klmiura]

Yes, Eva that is what I have and I receive #N/A for the result...I even made
sure they were all spelled exactly the same and in the same upper/lower case.
Any other suggestions?

 

[Max]

Try it with a TRIM around the lookup value:
=VLOOKUP(TRIM(A1),Sheet1!A:B,2,FALSE)
There could be extraneous white spaces here and there throwing apparent
matches off (this is quite common). And if the above still doesn't do it,
then you need to TRIM the vlookup's reference col ie Sheet1's col A as well.
Use a helper col to TRIM in Sheet1 (eg in Sheet1, in E1=TRIM(A1), copy down),
then copy the helper col and overwrite Sheet1's col A. Success? hit the YES
below