lookup if a number is within X of a range of numbers

Hello!

Here's the data structure:
Worksheet 1

12512517

9458273

731282

Worksheet 2

712751752	foo
847731	bar
12512515	tee

In worksheet 1, I want to put a formula in column B that does a lookup in worksheet 2 and return column B from worksheet 2 if the value in worksheet 1 column A is within 5 (plus or minus) of the value in worksheet 2 column A. In the example above, worksheet 1 A2 would be "tee".

Thank you!

This hit the mark exactly. Small requirement change. In addition to the original criteria, I'd like to know if Column C in worksheet 2 contains "scarf". If it does, return TRUE.

Try this formula:

=COUNTIFS(Sheet2!$A$1:$A$10,">="&A1-5,Sheet2!$A$1:$A$10,"<="&A1+5,Sheet2!$B$1:$B$10,"scarf")>0

Thank you all for your help. I'm just having trouble wrapping my head around this one. For the uploaded data, I want to refusals!K:K to be populated with TRUE/FALSE if these conditions exists (AND):
- refusals:epoch is within +5 seconds of agentlog:epoch (ignore values where agentlog:epoch is greater than refusals:epoch)
- refusals:FullName = agentlog:Agent
- agentlog:Action = "*Product Feedback | Salesforce*" (contains the string)




example.xlsx