Vlookup alternative

Hi Gents,

Just a quick one, i was looking over a spreadsheet i have been working on and wanted to ask some advice.

In the attached, the formula in columns B & I of the Quotation sheet seems to work ok, I just wonder if its the most efficient way to do what its doing, which is basically looking up the cost and labor time based on the text in column A.

Any suggestions? The reason i ask is that in another spreadsheet (a much larger one) it does not work for some parts of the data base.

Thanks in advance.

Adam