Match Q

Seanie · Jan 18, 2009

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?

Lars-Åke Aspelin · Jan 18, 2009

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

Bob Phillips · Jan 18, 2009

I presume that you meant BB1:BB7

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

Lars-Åke Aspelin · Jan 18, 2009

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

Seanie · Jan 18, 2009

Thanks guys, yes it was a typo

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