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
Bookmarks