index/index
Bobby, if I understand correctly, you have a 2-D table w/ various days
in the rows and timeslots occupying columns. Also, if I understand
correctly, in your formula you mean A1 not A9 (which is part of the
data). I.e., you have one full date-time specification in A1 and you
want to search the 2-D crosstabulation for the item on the specific
time.
If this is the case, then you need the following:
=vlookup(int(A1), $A$2:$Y$33, match(mod(a1,1), $B$2:$Y$2, 0), 0)
Does this help?
Kostis Vezerides
|