Match or Index Question

My data table is set-up like this:

DataTable Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX060 167 179.01 0 179.01
BOX234 0 0 0 0
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01

I am trying to create a table like this and think it is possible with index
and match functions:

New Table Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01
BOX898 No Match No Match No Match No Match


Is it possible ?

Thank you in advance.

Is there any reason why you can't just sort your list?

Insert a "helper" column and extract the 3 digits:

=--RIGHT(A2,3)
And copy down as needed.

Then select the *entire* list, including the inserted "helper" column, and
sort on the helper.
You can then delete the "helper".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"carl" <carl@discussions.microsoft.com> wrote in message
news:D4109BEE-AC0A-4C1F-A06B-94371340541F@microsoft.com...
> My data table is set-up like this:
>
> DataTable Raw Adjusted Special Total
> BOX050 90 96.67 0 96.67
> BOX060 167 179.01 0 179.01
> BOX234 0 0 0 0
> BOX355 104 115.34 0 115.34
> BOX549 156 166.01 2 168.01
>
> I am trying to create a table like this and think it is possible with
index
> and match functions:
>
> New Table Raw Adjusted Special Total
> BOX050 90 96.67 0 96.67
> BOX355 104 115.34 0 115.34
> BOX549 156 166.01 2 168.01
> BOX898 No Match No Match No Match No Match
>
>
> Is it possible ?
>
> Thank you in advance.
>
>

sort does not solve the problem. thank you anyways. need the formula to do
matching of the values.

"RagDyer" wrote:

> Is there any reason why you can't just sort your list?
>
> Insert a "helper" column and extract the 3 digits:
>
> =--RIGHT(A2,3)
> And copy down as needed.
>
> Then select the *entire* list, including the inserted "helper" column, and
> sort on the helper.
> You can then delete the "helper".
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "carl" <carl@discussions.microsoft.com> wrote in message
> news:D4109BEE-AC0A-4C1F-A06B-94371340541F@microsoft.com...
> > My data table is set-up like this:
> >
> > DataTable Raw Adjusted Special Total
> > BOX050 90 96.67 0 96.67
> > BOX060 167 179.01 0 179.01
> > BOX234 0 0 0 0
> > BOX355 104 115.34 0 115.34
> > BOX549 156 166.01 2 168.01
> >
> > I am trying to create a table like this and think it is possible with
> index
> > and match functions:
> >
> > New Table Raw Adjusted Special Total
> > BOX050 90 96.67 0 96.67
> > BOX355 104 115.34 0 115.34
> > BOX549 156 166.01 2 168.01
> > BOX898 No Match No Match No Match No Match
> >
> >
> > Is it possible ?
> >
> > Thank you in advance.
> >
> >
>
>