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