Lookup Text and Receive Other Text in Return

K

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:
 
E

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
 
K

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?
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top