=IFERROR(INDEX(Data!B:B, SMALL(IF((OR(Data!AG:AG='Working Date'!$A$1,Data!AR:AR='Working Date'!$A$1)), MATCH(ROW(Data!CM:CM), ROW(Data!CM:CM)), ""),ROWS($A$1:A1))), "")
Anyone able to tell me why this how to build this "OR" function into an index and match function?
11 freelancer chào giá trung bình$13 cho công việc này
Greetings I have more than two decades of experience of using excel and teaching excel. i can explain you immediately. I would explain untill you become expert of it. Thanks
Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun