INDEXing Question

[carl]

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.

 

[Anne Troy]

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]

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.

 

[Ashish Mathur]

Dear Carl,

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

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

Regards,

Ashish Mathur