centurymantra
New Member
- Joined
- Jan 30, 2017
- Messages
- 26
I ran into a very odd Excel quirk in which I was using this formula:
=IF(ISNA(VLOOKUP(A2,$q$2:$q$33,1,FALSE)), "Yes", "No")
For themajority of the column, this was returning correct results but I discovered afew instances where an exact match was returning "No". Theywere absolutely exact and I even went so far as to copyfrom the referenced cell and paste it into the table being usedand it would STILL return that it was not an exact match. It seemed likeit was occurring towards the bottom of the worksheet although I did not confirmthis.
Most of the results were correct, but there were just a fewrandom cells that were not returning the correct information.
Any ideas on what could cause this?
=IF(ISNA(VLOOKUP(A2,$q$2:$q$33,1,FALSE)), "Yes", "No")
For themajority of the column, this was returning correct results but I discovered afew instances where an exact match was returning "No". Theywere absolutely exact and I even went so far as to copyfrom the referenced cell and paste it into the table being usedand it would STILL return that it was not an exact match. It seemed likeit was occurring towards the bottom of the worksheet although I did not confirmthis.
Most of the results were correct, but there were just a fewrandom cells that were not returning the correct information.
Any ideas on what could cause this?
