Thanks for the quick response,

Say I have three sheets.

The first sheet (Master Sheet) is the sheet where I want my vlookup table
The second and third sheets are called (WTI) and (Brent).

How would I change the vlookup formula so that I can just simply drag across? I tried your formula and get #N/A in the cells.