index and match in a range

[Excel_Legend]

I am self-taught, so basically graduated from the University of YOUTUBE. Anyways, I have a workbook, in the first tab I am keeping track of items and who has them. Column A1:A500 are names, and columns B-N are equipment people can check out. Usually only one of those objects per person, however, column I holds ipads and column N holds keys. Those two columns are the only two that a person can hold multiples of. in different tabs I keep track of the different types of equipment from the columns in the first tab. In the IPAD tab A3 = sequence(40,,1,1), I have been working on creating a formula for two weeks for column B that shows who currently has a checked out item. In column O of the first tab, is the status of the whole line, in, out. so column B is for items that are currently out, and column C is for the last person who had that equipment out that equals in. so in column I of the first tab can be a number from 1-40, obviously that is easy to index and match, but what I am having problems with is you can also input a range like 5-13. So I have been trying to use a or,and, where the and is is the number greater than the first, and lesser than the second, or is = to the first or = to the second, or = to the cell. Because of the way i was checking it had to be in that order, if it was >= or <= the formula never checked out. here is a copy of where my code is currently.
=IFERROR(INDEX('EQUIPMENT LOG'!$A$6:$A$600, MATCH(1, (VALUE('EQUIPMENT LOG'!$I$6:$I$600)=A3)*('EQUIPMENT LOG'!$O$6:$O$600<>"IN"), 0)), "") this is what is in all the other tabs.
Column I also is in text format, in order to type in the range, and I just learned that I can use -- instead of the value function to return the value.
but thats just to return if there is a single number not a range.

I hope I made this understandable, if 'IPAD'!A3 which equals 1 appears in 'EQUIPMENT LOG'!I6:I100 or so, then the name needs to be placed in. if it is a number in a range same thing, and then I can pull it down to the 10 rows I have.

Please any help would be great.