Vlookup: Have problem. Not taking the object that i search...

[SupperDuck]

Hi.

I have part codes in my A column.

For example 10 parts in first column. And i have all part codes in column D
and have all prices for all codes in column E

I want to take the prices for that 10 parts and so use the vlookup.

But the codes are not in same style.

I mean in A they are as;

2G15 2144 2111
2G15 2144 2111

In first code, there is only one spece and in second there are 2.

My first question;

TRIM is used to clear the speces in front and back of of the sentence. I
want to clear all spaces in the column (not with find and replace ) So how
can i?

And i have the main question;

When i use the vlook function;

2t14a500td

can take the value of

2t14b500td or like it. But i want it to take the value of 2t14a500td

Why?

How can i give the correct number?

[Bob Phillips]

The first part is done with SUBSTITUTE

=SUBSTITUTE(A1," ","")

which you can use in another function.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SupperDuck" <[email protected]> wrote in message
news:[email protected]...
> Hi.
>
> I have part codes in my A column.
>
> For example 10 parts in first column. And i have all part codes in column
D
> and have all prices for all codes in column E
>
> I want to take the prices for that 10 parts and so use the vlookup.
>
> But the codes are not in same style.
>
> I mean in A they are as;
>
> 2G15 2144 2111
> 2G15 2144 2111
>
> In first code, there is only one spece and in second there are 2.
>
> My first question;
>
> TRIM is used to clear the speces in front and back of of the sentence. I
> want to clear all spaces in the column (not with find and replace ) So
how
> can i?
>
> And i have the main question;
>
> When i use the vlook function;
>
> 2t14a500td
>
> can take the value of
>
> 2t14b500td or like it. But i want it to take the value of 2t14a500td
>
> Why?
>
> How can i give the correct number?