### [Solved] LOOKUP function returns odd results

Posted:

**Sat Jul 20, 2019 3:37 am**Hey,

what's wrong with my fornula?

I attached screenshot to the post.

Both columns should be identical... shouldn't they?

In case the picture isn't too clear, the right row contains the formula and I typed in values in the left one.

I have Enable regular expressions in formula checked and Search criteria = and <> must apply to whole cell unchecked. Anyway I tried all combinations of check/uncheck, nothing changed. I'm guessing it has to do with the + and - symbols, but I can't figure out how to fix it... Can you guys help me out?

Thanks a lot

what's wrong with my fornula?

I attached screenshot to the post.

Both columns should be identical... shouldn't they?

In case the picture isn't too clear, the right row contains the formula and I typed in values in the left one.

I have Enable regular expressions in formula checked and Search criteria = and <> must apply to whole cell unchecked. Anyway I tried all combinations of check/uncheck, nothing changed. I'm guessing it has to do with the + and - symbols, but I can't figure out how to fix it... Can you guys help me out?

Thanks a lot