Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
Conditional Number Formats | Excel Discussion (Misc queries) | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel |