Hi all!

I found Ron's solution to be the easiest for me. It works like a charm
and I couldn't be happier. Question though - what is the last zero in
the formula for? Dave's link helped explain the second to last one.

Bob - your solution would have worked I think but honestly I had
trouble sorting out the pieces. I'm going to keep a copy of it on hand
though, because you never know where it might come in useful.

And Dave - I looked up your link and it helped translate the "0" in
Ron's answer.

Thank you all for your time and efforts in helping. This will save me
a great deal of headache going forward.

Mrs. Rum



Ron Coderre wrote:
Try something like this:

With
The extracted data in Capture!A1:D100
The display column headings in Display!B1:D1
The display row headings in Display!A2:A50

Then, on the Display sheet

B2: =VLOOKUP($A2,Capture!$A$1:$D$100,MATCH(B$1,Capture !$A$1:$D$1,0),0)
Copy that formula down and right to Display!D50

The formula uses a standard VLOOKUP, but uses the MATCH function to return
which column to use.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

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