Excel Cell Reference Problem
Posted on 2011-10-24
I have 2 data sets. I am pulling a small set of data from a larger set using VLOOKUP. For some reason, it is not finding the data, even though it is there. I know there is an issue with formatting. For example, If I am trying to Lookup "John Smith", it will not return a solution, but when I manually go to the sheet, retype "John Smith" in the same place, the same way, it finds it and returns a solution to my Lookup page. What am I missing? I tried changing the formatting to "text" on both sheets (in the Format Cells Menu), but that hasn't worked. It only seems to work when I re-type the exact same thing in the box.