I have spreadsheet which has the details of the boilers installed in a property. in column A, I have the make of the boiler, Column B have the model and Column C have the size. for eg.

Worcester Greenstar 28i.

Now I need to look up this info from another sheet which has all the boiler details and pull off the manufactured date.

Is there any was of achieiving this info without Concanating the 3 columns to 1 and using vlookup?

Thank you.