Lookup w/ aliases

Not sure if my Title made any sense, but I'm not very familiar with the lingo. Honestly my problem is I have no training, just self taught. Anyways, I have a lookup table that I need to expand and not sure if it is even possible?

With each name, there is a property number. But there are variances on the names. So is there a way to tell it to look in column b,c & d for a match rather than just look in b like it does now? Again I apologise if I sound like an idiot, I've attached a sample to explain more.

I paste the names on sheet1 and it pulls from sheet2

Thank you so much for any help that you can offer on this!