Ok, then you'll have to show us the *exact* formula you are using.

--
Biff
Microsoft Excel MVP


"Mindy" wrote in message
...
I have everything formatted as general. Should this be something
different?

"T. Valko" wrote:

Let's say if the description is "100# trains"....
my result only shows "100".

Are you using a custom number format in your table so that it displays as
100# trains? If so then you'll have to use the same format in your
formula
cell.

--
Biff
Microsoft Excel MVP


"Mindy" wrote in message
...
My formula appears to be working, but my result is not complete. For
example--I'm looking up a product code and want the description to be
my
result. Let's say if the description is "100# trains"....my result
only
shows "100". What do I need to do to get the rest of it showing?
(the
"#
trains" part)

Thanks!