Dave B. wrote:
Hello all,
I am having an issue of special formats making lookups fail. On 2 excel
sheets with data I need to merge, via lookup, both have multiple corrections
on them. The problem lies in this, the corrections are done by using the
"Strike out" feature, which causes errors in the lookup. Is there any way,
or special syntax I cna use, possibly in the find and replace menu, to find
ALL data with strike outs and remove them?
Thanks
Dave B.

Hi Dave B

Not sure what "strike out" is but if you mean Strikethrough, then that
should make no difference to your lookup, the value in the cell has not
been altered.

Regards

Steve