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.
Example of Text Strings:
(Redacted for personal information)
Everything is formatted as General
Vlookup String (=VLOOKUP(A2,BA!$A$1:$B$36,2))