Sheet name in formula

  • Thread starter Thread starter Kimberly
  • Start date Start date
K

Kimberly

I am trying to build a formula that will reference a cell on a sheet t
provide part of the name of a sheet from which I want to draw date.
For instance:
My workbook has 6 sheets; Smith comp|sched, Green comp|sched, Jone
comp|sced, Brown comp|sched, Johnson comp|sched, Schedule analysis.

On the Schedule analysis page, I maintain a column(call it Column A
listing the employees: Smith, Green, Jones, Brown, Johnson. I want t
write a formula that will find each employees comp|sched sheet an
return data from a specific place. I want to build this formula so
can just drag it down and it references Column A for the employee nam
and inserts it into the formula so the program knows where to go fo
the data I want. This way I don't have to change lots of things o
lots of pages when I change employees.
Can anyone help??? Thanks!
Kimberl
 
Hi
if your employee name is in A1 use the following in B1 to return the
respective cell A1 for this employee
=INDIRECT("'" & A1 & " comp|sched'!A1")
 
Back
Top