Creating a work order

[clemkonan]

My department has task that are executed daily, weekly, monthly and quarterly and these tasks have been placed in a name range list called "task" where the headers are A1= Frequency, B1= Form # and C1 = Task Description.

4 rows or lines of data reads as follows:
A2 =Daily B2 =27 C2= Preop inspection Check
A3 = Daily B3= 33 C3 = Scale Calibration
A4 = Weekly B4 19 C4 = Brittle plastic Check
A5 = Monthly c5 = 48 C5 = Freezer Calibration

So I have names this Range "Task"

I have a drop down list from which I can choose my frequency so lets say I choose daily meaning " show me the things I am scheduled to do daily"

How do I get the Vlook up to work so that it looks at the list which also has quarterly work, seni-annual work etc and only returns the weekly tasks.
Hopefully this makes sense if needed can I upload my sheet and if so how?

My output should be that I have to :do a pre-op inspection check and a scale calibration check.

Thanks in advance

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G
2	Daily	1	Op1			Daily	Op1
3	Daily	2	Op2				Op2
4	Weekly	3	Op3				Op4
5	Daily	4	Op4
6	Monthly	5	Op5
22

Cell Formulas
Range	Formula
G2	=IFERROR(INDEX($C$2:C6,AGGREGATE(15,6,(ROW($C$2:$C$6)-ROW($C$2)+1)/($A$2:$A$6=$F$2),ROWS($A$1:A1))),"")

 

[clemkonan]

I Never used the Index function before so I will have to look it up. Assuming I then wanted to extend my query so in real terms the employee is starting his /her shift and wanted to see what jobs are tasked for Daily, Weekly, Monthly how do we move to lets say the monthly query.

 

[Fluff]

Simply change the value in F2 to Monthly.