Microsoft Office Forums Values are missing from INDEX & MATCH Equation

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2019, 10:11 PM
suniltko suniltko is offline Values are missing from INDEX & MATCH Equation Windows 7 64bit Values are missing from INDEX & MATCH Equation Office 2010
Novice
Values are missing from INDEX & MATCH Equation
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 8
suniltko is on a distinguished road
Values are missing from INDEX & MATCH Equation
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, 9 views)
Reply With Quote
  #2  
Old 06-05-2019, 12:05 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Values are missing from INDEX & MATCH Equation Windows 7 64bit Values are missing from INDEX & MATCH Equation Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Without seeing data, difficult to guess.
Please post a sample sheet ( pics are useless).
Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Tags
iferror, index and match, value missing in output

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help using Index match for below Maneesh Joshi Excel 2 11-29-2018 06:23 AM
INDEX/MATCH Question huntld Excel 0 02-13-2017 12:51 PM
Excel - Index and Match Function ,First Second and Third Match paulzy95 Excel 10 09-29-2016 10:46 PM
Index match vba grexcelman Excel 0 03-05-2015 10:55 PM
UDF multiple IFs INDEX-MATCH grexcelman Excel Programming 0 02-22-2015 04:20 PM


All times are GMT -7. The time now is 10:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft