How to match numbers within a specific range of each other?

[fsanjaya]

Hi! I'm currently working on a project where I have to match a reference number to one number from a separate column that is within +/-3 of the reference or equal to the reference. What formula can I use to do this?

 

[fsanjaya]

I forgot to mention that the match I previously talked about is actually age and I'm trying to match based on ethnicity as well, so I need a formula that could include these 2 criteria at the same time.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also, some small sample data and expected results should help clarify what you have and what you want.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.