Mike,
See point 1. re what to put in A20. The Vlookup refers to A20 because
it is looking up the Sheet name (e.g StoreA).
I think the easiest way to explain this (as I can't attach my example
Excel file) is to attach a jpg of it. You can see the formula for
selected cell B2, and the result. The two boxes below show what I've
got in Monday's and Tuesday's sheet, so you can see the result being
returned comes from these values.
Hope this answers your questions.
Clive

MikeR-Oz Wrote:
Thanks But not working Clivey_UK,
WHY A20? SHOULD IT BE A2 WHICH IS THE DATA IN THE MONDAY SHEET AND IS
THE
NAME -STORE A.

OR USE A3 WHICH IS THE NEXT STORE NAME - STORE B, etc etc

then:-

A$2:$Z$100 is the range in the sheet 'monday' and is the data including
the
store names and the columns to z that include all the weeks data, for
mondays
over the 5 months

and then:-
COLUMN(B1))
is where to start placing the 'looked up' information for A2

Correct?

Then why is it not working? I just get a 0

Mike

[/color]


+-------------------------------------------------------------------+
|Filename: mike example.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4502 |
+-------------------------------------------------------------------+

--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=524402