Cell referencing

[navin]

Hi,

I have a sheet, which contains a metrics score card and a chart based
on this metrics. this metrics is created on every modays of a month.

i have created a list which shows all dates for monday in the month. I
want to put the data related to all the mondays in one single sheet and
based on the values selected in the list, data should be displayed in
the metrics columns.

Please help.

Regards,
Navin

 

[KC Rippstein]

Sounds like VLOOKUP should work for you. Check it out in Excel help.
VLOOKUP is very easy to use.
As an example, if you have 01/02/2007 in A1 of your Summary sheet and the
corresponding data is on various worksheets named Jan, Feb, Mar, etc. in
cells A1:B6, then you could do the following.
In C1, =TEXT(A1,"mmm")&"!$A$1:$B$6"
In B1, =VLOOKUP(A1,INDIRECT(C1),2,FALSE)
Then highlight B1:C1 and use the fill handle to drag those formulas down to
the end of your list of Mondays.
- KC