identify incomplete input in vlookup and match with correct result

im on the final part of this sheet. i have already identify the floor with the code. however, i need the C23 to be able to input not the whole book name. i need a formula that would identify part name and return the floor number. eg. social psychology -> soc*psych* when i enter that it would still return the correct floor. pros please help~~~ thank you!!!

Re: identify incomplete input in vlookup and match with correct result

i know the *, however for vlookup in my situation. its not a single input. it is a list of input. i tried vlookup("C23*" and vlookup(C23*. they all didn't work out. anything to suggest for the whole list in my situation?