Help With Index/Match Formula!!

[aross]

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??

[NBVC]

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)))

[aross]

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)))

0% is an acceptable answer sometimes so that formula does appear to work. could explain why there is a = and "," in the middle? That part of your formula is a bit confusing to me. Thank you!

[NBVC]

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.