INDEXing Question

I have my data in a table like this:

Data Table BOX017 BOX060 BOX161
A 109
B 38275 4
C
D

I am trying to find a formula to use in the body of this new table that will
give the results below:

New Table BOX017 BOX060 BOX161 BOX226
A 0 109 0 0
B 38275 0 4 0
C 0 0 0 0
D 0 0 0 0

Thank you in advance.

If you're trying to fill blanks with zeroes, try this. Select the range. Hit
Edit-->go to-->Blanks. Type a zero and hit Ctrl+Enter.
************
Anne Troy
www.OfficeArticles.com

"carl" <carl@discussions.microsoft.com> wrote in message
news:F42AA168-D9BB-4B69-8061-47B6365613C6@microsoft.com...
>I have my data in a table like this:
>
> Data Table BOX017 BOX060 BOX161
> A 109
> B 38275 4
> C
> D
>
> I am trying to find a formula to use in the body of this new table that
> will
> give the results below:
>
> New Table BOX017 BOX060 BOX161 BOX226
> A 0 109 0 0
> B 38275 0 4 0
> C 0 0 0 0
> D 0 0 0 0
>
> Thank you in advance.
>

Thanks but I am not trying to fill in the blanks with zero. The formating
makes it difficult to see but what I need is on the new table, the formula
looks at the value in
A2 and B1 finds the match in the data table (if there is one) and returns
that value. If there is no match, return a 0.

Regards.

"Anne Troy" wrote:

> If you're trying to fill blanks with zeroes, try this. Select the range. Hit
> Edit-->go to-->Blanks. Type a zero and hit Ctrl+Enter.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "carl" <carl@discussions.microsoft.com> wrote in message
> news:F42AA168-D9BB-4B69-8061-47B6365613C6@microsoft.com...
> >I have my data in a table like this:
> >
> > Data Table BOX017 BOX060 BOX161
> > A 109
> > B 38275 4
> > C
> > D
> >
> > I am trying to find a formula to use in the body of this new table that
> > will
> > give the results below:
> >
> > New Table BOX017 BOX060 BOX161 BOX226
> > A 0 109 0 0
> > B 38275 0 4 0
> > C 0 0 0 0
> > D 0 0 0 0
> >
> > Thank you in advance.
> >
>
>
>

Dear Carl,

Assuming your data table is in range A1:D5, try the following formula:

=INDEX($A$1:$D$5,ROW(A2),COLUMN(B1))

Regards,

Ashish Mathur

"carl" wrote:

> I have my data in a table like this:
>
> Data Table BOX017 BOX060 BOX161
> A 109
> B 38275 4
> C
> D
>
> I am trying to find a formula to use in the body of this new table that will
> give the results below:
>
> New Table BOX017 BOX060 BOX161 BOX226
> A 0 109 0 0
> B 38275 0 4 0
> C 0 0 0 0
> D 0 0 0 0
>
> Thank you in advance.
>