Match Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

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?
 
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?
Click to expand...


What is "the corresponding cell"?

Lars-Åke
 
I presume that you meant BB1:BB7

=INDEX(BB1:BB7,MATCH(TODAY(),BA1:BA7,0))
 
What is "the corresponding cell"?

Lars-Åke
Click to expand...

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
 
Thanks guys, yes it was a typo

=INDEX(BB1:BB7,MATCH(TODAY()-1,BA1:BA7,0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to make a sum function always equal the corresponding cell 2
column data retrieved based on value in header row 2
Dragging Cell References/Formulas 5
How to determine the cell location? 2
IF AND OR functions 3
change textbox size 1
Issue with workbook not being selected when form button is clicked 3
update formula in column when another cell formula is changed 1

Back
Top