I have a file and am looking in column E and G. If Column E="Bob's" and column G="1234", I'd like a message to pop up stating "abc". How do I write this. I have the code below, but that only looks at individual columns.
Sub Bob's()
If Range("E3:E30").Value = "Bob's" Then MsgBox "If this Bob's...