Values are missing from INDEX & MATCH Equation
Hi All,
See attached snap. I've used INDEX & MATCH equations to tabulate these details. Here, I've added a time frame 8:30 AM to 6:00 PM for training. But clouded cells NOT giving the output correctly and getting a blank cell as clouded. How I can bring back the values here?
Used equation is : =IFERROR(INDEX(tTimeTable,MATCH(B$3&$A10,tTimeTabl e[Match Data],0),6),"")
Thank You,
Sunil Thomas
|