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?