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