DeskBandit
New Member
- Joined
- Apr 26, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I've got a rather bizarre Excel problem that I have never seen before. I am trying to reconcile accounts in two different systems, and I am not able to easily do so because, for a number of accounts/row labels ending in the number "1", the lookup is instead returning the value for the row with a "0" at the end. This behavior is not occurring with any other ending numbers and it persists after any kind of data manipulation I can think of for the column ID's (keeping the extract formula intact, general data types, copy-paste values as both text and numbers, etc).
The formula is set to use exact matching already. Removing the match type from the formula does not impact the behavior.
The formula is set to use exact matching already. Removing the match type from the formula does not impact the behavior.