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 week no from 1 to 52. In Cell A6 pick up the 1st date of that corresponding week. In Cell C6 pick up the 2nd date of that corresponding week and in cells A9 and A10 enter the engineer name and phone number. Ideally I want the sheet to automatically enter all the information in those cells by entering the week number only in cell B3.

Please help.

3 Replies

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

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

Resources