Code for multiple search

Hello, I want to write a code that allows me to look in multiple columns for specified entries.
For example, I want to search column A for the word "John", if found, I want to check column B for hours 1:00, if found I want to check column C for hours 1:00, finally if found, I want to check column D for the letter "C".
And in the end, return the number of the row so I can use it in my code.
In the sample below, the code should return the number 9.
I have a lot of entries in a sheet1, I am trying to build a code, that will look in the sheet1 if specific entries (which I provide in sheet2) exist.
Is this possible?
Any help will be appreciated. Thanks