I have 4 columns in an MS Excel file, I want to search for a specific word for the specific range from the whole column. Please suggestme the formula

I have 4 columns in an excel file, column A contains the values of kilometers starting from 0 to 300, column b contains the letters, PH, PP etc. I want to search "PP" within every 1.6km interval i.e. 0-1.6, 1.6-3.2... and the function should return for every 0-1.6, 1.6-3.2... if there is a word "PP" in the other column.