Match Q

[Seanie]

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]

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]

I presume that you meant BB1:BB7

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

 

[Lars-Åke Aspelin]

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]

Thanks guys, yes it was a typo

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