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?
Ron Rosenfeld said: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 said: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