Ok I have a table array that is preety in depth.
It works off of an agent # unique and sortable.

A vlookup formula popluates the agent name and
additional info based off the #.
Ok here is the problem, the agent # is assigned to an office office code.
So in other words the agent produciton is paid into that office code. well
from time to time we re-profile these guy under new office codes.
The code has an inception date, so on
JAN 1st agent 177721 might be under office code 401895 and
then aug he has moved to office code 401913. His producion is dated
as well.
Question, how can I stucture this were data intry for the date of
production will return the correct office code by the codes inception dates??

please ask quesitons if you do no understand mine.

lets say column b is the date of the production and col
c is the agent #, col d-g, are random data agent name ect.
and col. h is the office code.
how can incorpoate the date in the array to return the correct offic code