View Single Post
 
Old 06-04-2019, 10:11 PM
suniltko suniltko is offline Windows 7 64bit Office 2010
Novice
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default 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
Attached Images
File Type: jpg Value Missing.JPG (192.0 KB, 13 views)
Reply With Quote