dphine00
asked on
Excel Vlookup
I am using Vlookup to lookup text in a text string in Column 1 on Workbook 1 against column 2 in Workbook 2 I want to return the contents of column 1 in Workbook 2, if there is a match. Sometimes this works perfect, but the majority of the time, it doesn't what am I doing wrong. The format is general.
Because of company policy I cannot attach the file, but if I can talk to someone that would be great, however, if the expert can give me a way to communicate with them, that would be great.
Version 2013
Example of Text Strings:
(Redacted for personal information)
Everything is formatted as General
Vlookup String (=VLOOKUP(A2,BA!$A$1:$B$36 ,2))
Because of company policy I cannot attach the file, but if I can talk to someone that would be great, however, if the expert can give me a way to communicate with them, that would be great.
Version 2013
Example of Text Strings:
(Redacted for personal information)
Everything is formatted as General
Vlookup String (=VLOOKUP(A2,BA!$A$1:$B$36
ASKER
Hi Wayne, I have added the 0, and False, and I am getting the same results. Let me save a version that I can share.
ASKER
I have added the file
b00k1.xlsx
b00k1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It worked.
While I understand company policy prevents you from posting the actual workbook you are working on, and version with any confidential information removed would greatly assist us in providing you with a formula.
However, looking at your formula, you are omitting the 4th parameter which specifies whether to look for exact matches. Perhaps try adding FALSE or 0 and see how it goes...
=VLOOKUP(A2, BA!$A$1:$B$36, 2, 0)
Wayne