Forum Discussion
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.
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
- Thank you very much Sergei. I was under the impression it was VLOOKUP I needed to add.
VLOOKUP could work as well, INDEX/MATCH is just my personal preference
