If 0% is actually acceptable result sometimes, then best to use an IF...
e.g.
=IF(INDEX(I$5:I$25,MATCH($F$3,$F5:$F25,0))="","",INDEX(I$5:I$25,MATCH($F$3,$F5:$F25,0)))
I'm tracking the percent complete (PPC) for individuals and their assigned tasks. I have a problem where index/match returns a "0%" complete if the cell is blank in between cells that have a value. 0 implies that this person failed alPPC Progress Data Organization.xlsl of their tasks, when in truth, they just weren't assigned any new tasks. Since I use this data in a graph it would be very miss interpretive if the "0%" exists in the data. however, when there is no data in the cell to the right of it "" will show up. I guess a blank and a 0% show up the same in a graph, but if one is looking at the raw data a 0% is misleading compared to an empty cell.
Attached is the spreadsheet im refering to, can someone please help me out??
If 0% is actually acceptable result sometimes, then best to use an IF...
e.g.
=IF(INDEX(I$5:I$25,MATCH($F$3,$F5:$F25,0))="","",INDEX(I$5:I$25,MATCH($F$3,$F5:$F25,0)))
If the result of the INDEX function is a null then return a null else return the INDEX function result. The double quote set signifies a null.
Bookmarks