Ok, good deal!

--
Biff
Microsoft Excel MVP


"Mindy" wrote in message
...
I found a way around this. I think it must have done with me combining
cells
& pulling from that. I copied and did a "paste special" with the values &
ran my lookup table from that & it worked! :)

"T. Valko" wrote:

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!