 <p>With a layout as shown in the example and the range in Sheet1 named <code>array</code> <code>=VLOOKUP(A2,array,2,FALSE)</code> should show in ColumnC the value from the Sheet1 cell immediately to the right of the value as specified in <code>A2</code> (of Sheet2). The same formula in <code>D2</code> with <code>,2,</code> replaced <code>,3,</code> should give the corresponding unit price, so appending <code>*B2</code> should give the Cost. Both formulae may be copied down to suit: </p> <p><img src="https://i.stack.imgur.com/Y38qX.gif" alt="enter image description here"> </p>