VLOOKUP formula showing in the cell.

[Geek Girl 007]

I use VLOOKUP for allot, but recently I have experienced this, can anyone make a suggestion?
The information it is reading I believe is VALUES??

Difficult to upload the exact sheet as it has sensitive information on it.

 

[Alex Blakenburg]

How is the column formatted ? My guess it is formatted as text, if so change it to general. Click in the formula bar and press enter. Then copy the formula down to all the rows.

 

[Geek Girl 007]

How is the column formatted ? My guess it is formatted as text, if so change it to general. Click in the formula bar and press enter. Then copy the formula down to all the rows.

Oh my gosh, I can not believe it was as simple as that, I spent 2 days on this....Thank you so very much

 

[Alex Blakenburg]

No problem. Can I also suggest that you change how you are referencing the lookup range.
We normally discourage using whole column referencing because it is inefficient and slow excel down. Using 1:1048576 would be the absolute worst case scenario since it is referencing the "Entire Sheet".
Since you want to return column B at least change it to:
[Raw Data.xlsx]Data!$A:$B ideally you limit the number of rows or use a Table so that you can use Table references to limit the number of rows being scanned by the lookup.

 

[Geek Girl 007]

No problem. Can I also suggest that you change how you are referencing the lookup range.
We normally discourage using whole column referencing because it is inefficient and slow excel down. Using 1:1048576 would be the absolute worst case scenario since it is referencing the "Entire Sheet".
Since you want to return column B at least change it to:
[Raw Data.xlsx]Data!$A:$B ideally you limit the number of rows or use a Table so that you can use Table references to limit the number of rows being scanned by the lookup.

That is REALLY helpful, Thank you