Need crosstab function in excel
 

I have text in column and rows and I want it to pull the data in the
intersection. It would be similar to the index function except it would be
tied to the text not the row or column numbers. For example, my spread
sheet has car manufacturers (e.g. VW) in columns and models (e.g., Passat) in
the rows with 2005 sales in the intersection. I would like to use some sort
of lookup to automatically pull the data in the intersection

Need crosstab function in excel
 

I think what you're looking for is called a Pivot Table in Excel. Highlight
your data, then Data / Pivot Table. The wizard will guide you through.
Personally, I find it easiest to click Next twice confirming the range of
data, then click on Layout. From there, drag the manufacturers to the Column
field, Models to the row field and your sales data to the Data field. Note
the label you see in the data field; you might get 'count of' instead of
'sum of'. If so, just double-click and make the appropriate choice.
--Bruce

"patrick" wrote:

I have text in column and rows and I want it to pull the data in the
intersection. It would be similar to the index function except it would be
tied to the text not the row or column numbers. For example, my spread
sheet has car manufacturers (e.g. VW) in columns and models (e.g., Passat) in
the rows with 2005 sales in the intersection. I would like to use some sort
of lookup to automatically pull the data in the intersection

Need crosstab function in excel
 

I believe best way to achieve this is using names. First select range of
your table including header row, and leftmost column. Then go to
Insert-Name-Create, and check left/right column and top/botom row, depends
how your data are organized. You can check your names by calling Define name
dialog box (there should be all manufacturers from header row, and models
from left column). If its everything ok, simply make formula like this:

=VW Passat

There is space betwen this two names, which is intersection operator in
excel.

"patrick" wrote in message
...
I have text in column and rows and I want it to pull the data in the
intersection. It would be similar to the index function except it would
be
tied to the text not the row or column numbers. For example, my spread
sheet has car manufacturers (e.g. VW) in columns and models (e.g., Passat)
in
the rows with 2005 sales in the intersection. I would like to use some
sort
of lookup to automatically pull the data in the intersection