Working With Worksheets

  • Thread starter Thread starter rayscar
  • Start date Start date
R

rayscar

I'm working on a worksheet named "Schedule". Names appear in the
leftmost column in the range A8:A84 and dates appear in a row in the
range A3:Q3. In the body of the worksheets are the location/shift
abbreviations people work such as CC 0700, Central 1230, Peds 0700,
etc,.

I'd like to create another worksheet called "Locations" which lists all
the location/shift abbreviations in the leftmost column and the dates in
the same row range A3:Q3 across the top. In the cell (let's call it
cell B4) where the date of 01/11/04 intersects with the location/shift
on the left, I'd like to be able to pull the name (text) from the
Schedule worksheet. This will in effect give me another view by
location of which people are working in a given area on a given date.

What is the formula which should go into cell B4?
 
One way:

Assuming the dates in sheet Schedule!A3:Q3 match Locations!A3:Q3.

B4: =INDEX(Schedule!$A:$A,
MATCH($A4,OFFSET(Schedule!$A:$A,0,COLUMN()-1,,1),FALSE))

Copy down and across as far as necessary.
 
Back
Top