Sounds like your index match is returning text. Try using the Value function
to coerce the returned value to a number (instead of multiplying by 1)...
=value(index(...(match(...)))
--
HTH...

Jim Thomlinson


"JE" wrote:

This may be an obtuse question. I used the INDEX/MATCH function to return a
number from another worksheet. I am using this number in another forumula
and receive #VALUE!. However, when I type over the number returned from the
INDEX/MATCH, the formula is successful. I attempted to multiply 1 times the
end of the INDEX formula but that did not work. Any suggestions?

Many thanks.