=INDEX(SetUp!$C$2:$Z$16,MATCH($O50,SetUp!$A$2:$A$16,0),MATCH(P$1,SetUp!$C$1:$Z$1,0))

On the sheet the formula is in I have data from row P2:DV2.

P2 is a formula =MIN('Scheduling Setup'!C2:F2)) to get the earliest time available between two cells

P3 and on is a formula =IFERROR(IF(P2+TIME(1, 0, 0)<max('scheduling setup'!$c$3:$f$3),p2+time(="" 1,="" 0,="" 0),="" ""),="" "")="" to="" add="" one="" hour="" until="" the="" greatest="" time="" available="" from="" another="" cell="" create="" a="" window="" of="" time.

P1 and on is a helper formula to convert the time in P3 to "hA/P"

O3:O113 is a list of names that vary in order

On Sheet "SetUp"

A2:A16 has a Master List of names in the same format and spelling used on the other sheet

C1:Z1 is a list of times from 5A-4A formatted as "hA/P"

C2:Z16 is a grid with "X" in a cell that corresponds with the time that name is on shift during a single workday

I am trying to get the formula to pull the "X" over into the appropriate cell to essentially create a simple GANNT chart to show time of availability.

That seems like headache to think about, can't post a preview of the sheet.....

Hope i explained it well enough to make sense..

Thanks in advanced.</max('scheduling>