On Sun, 18 Jan 2009 14:26:06 GMT, Lars-Åke Aspelin
wrote:

On Sun, 18 Jan 2009 06:04:18 -0800 (PST), Seanie
wrote:

How could I create a formula that would find Today()-1 in a range
BA1:BA7 and return the value in the corresponding cell in BB1:BB2?


What is "the corresponding cell"?

Lars-Åke

If we should read BB1:BB2 as BB1:BB7 you may try VLOOKUP, like

=VLOOKUP(TODAY()-1,BA1:BB7,2,0)

Hope this helps / Lars-Åke