Hello!

I'm sure this has been answered ad naseum however I don't know enough
to translate the questions never mind the answers - So I would like to
pose the question in my own way. I hope that someone can help and I
appreciate any direction I receive.

I have a worksheet (Hereafter "Capture") that adds one column of data
each day (via a Microsoft Query connection to Microsoft Access, if that
matters). I then use a 2nd worksheet to display the data (make it
pretty as it were - hereafter "Display")

The information from Access is very simple: My column headings are
dates and my rows are store locations and the intersecting data is the
number of sales for that store on that day. On my "Display" worksheet
I use a combination of HLookup/VLookup to return data from my "Capture"
worksheet. It's functional. But I have to maintain a high level of
trust that things stay where they started when I built the thing.

To fix this I would like to know if there is a function where I can say
to Excel "If this column heading in "Display" matches a column heading
in "Capture" AND this row heading in "Display" matches "Capture" please
return the sales number for that day and store".

Thank you in advance for your time and direction.

Mrs. Rum