Hello,

I have a data array I am looking up data in. When I use the following
function: INDEX(Data!$N$2:$R$5000,MATCH(A52,Data!$R$1:$R$500 0,0),1), the
function retruns 3 possible values: #N/A if the lookup value is not found,
the actual value I am trying to return from column 1 of the array and a 0. I
don't understand why this is returuning a 0 for some of my lookups. I checked
the help on both INdex and Match and did not see anything. I checked the
function and I don't think there is anything wrong with the setup. Has anyone
ever seen this before?

Thanks,
Mike