index match return value

I think that your request may have ben misunderstood.... You can't (sa far as I'm aware) tell Excel to put ht evalue elsewhere. you can copy the value to another cell, or put the formula to the palce where you want the answer to be. I also think that if you were to explain better (with a sample sheet) what you want (and why) it might be possible to come up with an alternative.