Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |