VLOOKUP results displays ##### in some. Why?

[Guest]

Person A enters new or additional comments on Workbook 1. I have a VLOOKUP on
Workbook 2 that retrieves those comments but somethimes it displays just ###
signs. I have formatted the text to wrap. I have replaced the formula on book
2 with a new VLOOKUP formula in hopes of correcting the error but it does
not work. Is it possible that there is some symbol in the book 1 comments
that is causing this to happen?

 

[Guest]

Increase your column width

 

[Guest]

I tried increasing my column width - now I have a hundred # signs!

 

[Guest]

Is it possible that the vlookup is returning a negative number and your range
is formatted as date (or time?)

 

[Guest]

The VLOOKUP pulls Comments from the other workbook. Here is what it is trying
to pull:

10/6/06-Called requesting blah. This is "final" blah. It's tied to X01111
which hasn't blah. Working to blah. 10/16/06-P.O. Change blah. Working
blah X01111 issue blah.

The same type of comments are in this column and 98% of them are pulling
across without all those #### signs!

I tried removing the quote marks from book 1 but that did not correct the
issue.

 

[Gord Dibben]

I see that the example string contains 175 characters including spaces.

I'm not sure what "blah" rerpresents.

Longer text string perhaps?

If so.............One other potential cause for #############

Excel has a problem with cells that contain >255 but <1024 characters.

Fornat the cell to General and your ############## should go away.


Gord Dibben MS Excel MVP

The VLOOKUP pulls Comments from the other workbook. Here is what it is trying
to pull:

10/6/06-Called requesting blah. This is "final" blah. It's tied to X01111
which hasn't blah. Working to blah. 10/16/06-P.O. Change blah. Working
blah X01111 issue blah.

The same type of comments are in this column and 98% of them are pulling
across without all those #### signs!

I tried removing the quote marks from book 1 but that did not correct the
issue.

Gord Dibben MS Excel MVP

 

[Guest]

Formatting the cells to General took care of the problem! Thanks a zillion.

BTW: The "blah" was confidential text.

 

[Gord Dibben]

Thanks for the feedback.


Gord

Formatting the cells to General took care of the problem! Thanks a zillion.

BTW: The "blah" was confidential text.

Gord Dibben MS Excel MVP