Hi,

I want to use an offset formula to select a range of cells that I will use as a series in a chart. However, not only does the number of cells in the range vary (hence, the offset formul), but the location of the reference cell is not fixed; it also varies by date.

What I'm looking for is a way to specify the address of that reference cell. I tried using the CELL function combined with a VLOOKUP function:

=CELL("address",VLOOKUP(date,table,1,false))

But if I try that I get the message, "The formula you typed contains an error."

How could I go about doing this?

Thanks,
Christiaan