Forum Discussion
dantegarzia
Apr 26, 2024Copper Contributor
Formula returning the incorrect value
I am trying to lookup the value in cell A2 in column H and return a Yes if that value is in Column H and a No if it is not. I have tried using the below formulas, but it keeps returning "No" on value...
dantegarzia
Copper Contributor
It returned FALSE when I put that formula into a blank cell referencing what I highlighted in yellow.
Riny_van_Eekelen
Apr 26, 2024Platinum Contributor
dantegarzia Then they don't contain the same values. would need to guess without seeing the file. Can you upload it to Onedrive or similar and post a link here?
- dantegarziaApr 26, 2024Copper ContributorI am unable to upload the spreadsheet, but I do understand what you are saying. I just manually typed in the number into both cells and it returned the correct value. Could it be from copying each set of data from a different spreadsheet as that is where it originated and I moved it to a new sheet to manipulate.
- Riny_van_EekelenApr 26, 2024Platinum Contributor
Yes! Copying from different sources can cause such side effects. Especially when the copy and paste from the web is involved at some stage.
- dantegarziaApr 26, 2024Copper ContributorIs there a type of special paste that would help to solve this issue or would working with the data in the original spreadsheet be the best option for this? I was hoping to avoid the original spreadsheet as it contains thousands of lines and is extremely slow.