'MATCH function doesn't find equal cells
I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data should be copied.
I'm using the function match to detect the index on a table like this:
=MATCH(Y4;DataBase[Time];0)
The match function is not returning any value, just #N/A. I've already tested it with some cells and when doing
=Cell1=Cell2
True
It returns a true value, confirming they're equal, but =Match doesn't seems to find them.
Link to the bit of datasheet that troubles me
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|