View Single Post
  #1   Report Post  
patrick
 
Posts: n/a
Default 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