Forum Discussion
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...
Is 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.
dantegarzia Can't tell without knowing what's causing this. Sorry.
