Hi all,

I am using an "If" formula here, I think.

I have two columbs of work I need to reference.

For example:

Cell J2 will have in it "5293 - Meeting Minutes" and cell L2 will have "#5293 - Meeting Minutes"

There are hundreds of lines of data and it's a pain in the you-know-where to eyeball to make sure if all of these match up.

So I want to create a formula that will remove the "#" the L column so that I can do a formula like this below and copy/paste everything down (I probably need to copy and paste this into another cell, I would assume) so that I can have a formula in another cell that will allow me to show something like this:

=IF(J2=L2,"OK","CHECK")

Does that make sense?
Maybe I haven't had enough coffee today.

Thanks!
Favs