That would be fine if the data were always in the same location, but I am
dealing with a national spreadsheet. Names come and go, and categories
change. I need to find specific info on my reps only. Thank you, though. I
did learn something from Debra's notes. Using her table as a reference, I
need to know how many medium sweaters there are, just imagine a worksheet a
thousand times larger with more products and sizes/colors, etc. and the
creator can't keep them in the same spot.

"Dave Peterson" wrote:

It sounds like =index(match()) would work nicely:

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions03.html



Cellzman wrote:

I have a report I use that has more info than I need to deal with. I would
like to be able to create a worksheet that would allow me to pull information
from that report by referncing the labels that have the information. For
example, I might want to know how many sales a rep has. I want Excel to go
into the report and look for New Sales along the top and Sarah along the side
and give me the number. The position of this data changes frequently, so I
cannot reference cell locations or columns and rows. Can this be done in
Excel?

--

Dave Peterson