how to use match function and get result as ture if condition is true then match function

hello everyone,

i have attached a screenshot and excel file with this post.

what i want to do is:
1. when we give a value in search box, it should check 'item no. reference' to match 'search box' value, if found then check all table numbers and match with column B and column C right side digits only, and if match found it should print 'in stock' as result in column E and if not found any match it should print 'out of stock'.

ie. we can see we have value 7 in 'search box B2, so it's given result as 'in stock' because match found b2,f2:f11, then it checked for match f8 row and again match found with in all table numbers with c2 row 'part no' and checked c2 and d2 right digits.

Any help will we appreciate.

Thanks & Warm Regards.