Forum Discussion

Jess Beckett's avatar
Jess Beckett
Copper Contributor
Nov 07, 2018

Formulas????

Hi im new to formulas and cant get my head round it.  I have a table with the information I need in sheet 1 and a print off sheet called engineer on call. What I need to do in cell B3 is pick up the...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 07, 2018

Hi Jess,

 

For the first date of selected week is

=INDEX(Sheet1!B1:B52,MATCH(B3,Sheet1!A1:A52,0))

and similar for other fields, please see attached

 

  • Jess Beckett's avatar
    Jess Beckett
    Copper Contributor
    Nov 07, 2018
    Thank you very much Sergei. I was under the impression it was VLOOKUP I needed to add.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 07, 2018

      VLOOKUP could work as well, INDEX/MATCH is just my personal preference

Resources