Home |
Search |
Today's Posts |
#1
|
|||
|
|||
matching data formula?
I am trying to match data in a table so I can make a pivot table. I have a
list of products that I need to match the manufacturer name so I can include Manufacturer as a category. The manufacturer names are in the Header row G9 - T9 (via a match formula from another sheet) Product names are in G10:T9 (linked from another sheet) I want to insert the manufacturer name in column F if a product is used. The data is in G11:T11 to G2500:T2500 Basically I have either a 0,1,2 or3 in the data. And I want to insert the manufacturer name for any row that <0. F G H etc.. Manufacturer1 Manufacturer2 Product Name Product Name =manufacturer2 0 1 =manufacturer1 1 0 Any ideas? TIA Todd |
#2
|
|||
|
|||
For every column, not row. Sorry about that.
"Todd" wrote: I am trying to match data in a table so I can make a pivot table. I have a list of products that I need to match the manufacturer name so I can include Manufacturer as a category. The manufacturer names are in the Header row G9 - T9 (via a match formula from another sheet) Product names are in G10:T9 (linked from another sheet) I want to insert the manufacturer name in column F if a product is used. The data is in G11:T11 to G2500:T2500 Basically I have either a 0,1,2 or3 in the data. And I want to insert the manufacturer name for any row that <0. F G H etc.. Manufacturer1 Manufacturer2 Product Name Product Name =manufacturer2 0 1 =manufacturer1 1 0 Any ideas? TIA Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |