Match Q
 

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?

Match Q
 

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

Match Q
 

I presume that you meant BB1:BB7

=INDEX(BB1:BB7,MATCH(TODAY(),BA1:BA7,0))

--
__________________________________
HTH

Bob

"Seanie" wrote in message
...
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?

Match Q
 

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

Match Q
 

Thanks guys, yes it was a typo

=INDEX(BB1:BB7,MATCH(TODAY()-1,BA1:BA7,0))