IF this help already exists elsewhere I can’t find it - -apologies, I spent an hour scouring the web

I have a list of people with salaries
I have a list of 40+ salary bands (i.e. 5,000 to 6000, 6,000 to 6,500 etc)
Each salary band has a reference (no)

I need to find out that reference (no) in relation to the salary

So Dave is on 5,600 and I need to know which Band No he falls into basically

Short of having 40+ IF’s in one formula is there a lookup or shortcut?

I would upload an attachment if only I could work out how to get rid of the others I’ve loaded previously because it seems it won’t let me load another!