Lookup not returning complete result
 

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!

Lookup not returning complete result
 

It is VLOOKUP right? Check out help on VLOOKUP() on the 3rd and 4th parameter.

3rd one is the column number of the array..If your array is B1:D10 and if
you want to retrive columnD information the column number is 3

4th parameter if 0 will look for an exact match

If this post helps click Yes
---------------
Jacob Skaria


"Mindy" wrote:

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!

Lookup not returning complete result
 

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!

Lookup not returning complete result
 

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!

Lookup not returning complete result
 

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!

Lookup not returning complete result
 

=VLOOKUP(I2*1,'[Carbonless Roll & unc Stock
List-Mindy.xls]Sheet1'!$A:$M,2,FALSE)

I have to use the *1 because I will get #N/A if not. (It is looking at a
product number & I need it to return a description)

NOW--part of the table that I'm pulling from has cells combined & it looks
like this:
=B583&"#"&D583&E583&F583&H583&I583

Thanks!!!

"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!

Lookup not returning complete result
 

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!

Lookup not returning complete result
 

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!