I'm not sure how to explain this. I have a formula Index/Match referencing a table that apparently recognizes the referenced activecell (J3) number 1 as text or vice versa.
The formula worked fine before I formatted the data as a table. I needed the data in table format in order to allow for table growth. The named ranges are used in the formula. I have cleared formatting on both reference table and sheet that contains formula and formatted cells to number with no trailing zeros,but to no avail.
When I debug:
?activecell.value (201 sheet)
1 not sure why there's a space
?activecell.value(ISales table)
1
?activecell.text (201 sheet)
1
?activecell.text (ISales table)
1
I hope this makes sense.
I'm sure the forum will find it quickly as I've been beating my head.
thank you in advance
CC
Bookmarks