Hi Friends,

I am getting #N/A error while using INDEX MATCH function. The reason for this is that the cell for the lookup_value has a formula. If I remove the formula in lookup_value cell the INDEX MATCH function works well!!

How can I fix this problem.

Thanks,