View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff
 
Posts: n/a
Default Update a cell with a specific value related to a date.

I have an array of data in a 2 dimisional matrix

X = date value
Y = Individual contributor

In the Matix I have plotted the expected amount of work left by an
individual on a specific date.

I would like to create a formula that can look at the date value in row 2
and return the correct value for the individual contributor on that specific
date.

Any Ideas


--
Jeff