Matching number formats
 

I am using an INDEX/MATCH formula and do get a "VALUE NOT AVAILABLE"
response. Both ranges have a "General" format. A [Copy][Paste
Special][Formats] does not make the formats match. How can I make them
respond to each other?

On Thu, 12 May 2005 10:36:09 -0700, "raystub"
wrote:

I am using an INDEX/MATCH formula and do get a "VALUE NOT AVAILABLE"
response. Both ranges have a "General" format. A [Copy][Paste
Special][Formats] does not make the formats match. How can I make them
respond to each other?

If you post your formula, and some samples of the data, I'm sure someone will
be able to help. Also post the desired result from that sample data.

The "VALUE NOT AVAILABLE" result is not a standard feature of the built-in
INDEX or MATCH worksheet functions.

And cell format has nothing at all to do with how those functions work.


--ron

Thanks, Ron.
I did accomplish my goal, but it took a long time.
I formatted both ranges as text and then I had to go down the entire list
and press [F2] [Enter] on each cell. For some reason, this worked.
I would still like to know from anyone if there is a better way of matching
these formats.

"Ron Rosenfeld" wrote:

On Thu, 12 May 2005 10:36:09 -0700, "raystub"
wrote:

I am using an INDEX/MATCH formula and do get a "VALUE NOT AVAILABLE"
response. Both ranges have a "General" format. A [Copy][Paste
Special][Formats] does not make the formats match. How can I make them
respond to each other?

If you post your formula, and some samples of the data, I'm sure someone will
be able to help. Also post the desired result from that sample data.

The "VALUE NOT AVAILABLE" result is not a standard feature of the built-in
INDEX or MATCH worksheet functions.

And cell format has nothing at all to do with how those functions work.


--ron

On Fri, 13 May 2005 10:28:03 -0700, "raystub"
wrote:

Thanks, Ron.
I did accomplish my goal, but it took a long time.
I formatted both ranges as text and then I had to go down the entire list
and press [F2] [Enter] on each cell. For some reason, this worked.
I would still like to know from anyone if there is a better way of matching
these formats.

It is likely there is a much simpler method than what you describe. But
without more details, it is not possible for me to advise you further.


--ron

Thank you for trying, Ron.
I don't know how to describe it more clearly.
I don't know hot to send copies of the data to the discussion group.



"Ron Rosenfeld" wrote:

On Fri, 13 May 2005 10:28:03 -0700, "raystub"
wrote:

Thanks, Ron.
I did accomplish my goal, but it took a long time.
I formatted both ranges as text and then I had to go down the entire list
and press [F2] [Enter] on each cell. For some reason, this worked.
I would still like to know from anyone if there is a better way of matching
these formats.

It is likely there is a much simpler method than what you describe. But
without more details, it is not possible for me to advise you further.


--ron