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.