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

Attached Images

Value Missing.JPG (192.0 KB, 13 views)

Without seeing data, difficult to guess.
Please post a sample sheet ( pics are useless).
Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post