 <p>It isn't <code>OFFSET</code> that stops this working - your basic <code>VLOOKUP</code> won't work because the "table array" needs to be 2 columns at least if you have the "col_index-num" as 2</p> <p>What are you trying to do with this formula?</p> <p><code>=VLOOKUP($B6,$C$30:$C$36,2,0)</code></p> <p>If you want to look up B6 in C30:C36 and find the corresponding value in the next column you need to use this version</p> <p><code>=VLOOKUP($B6,$C$30:$D$36,2,0)</code></p> <p>Note "D" in place of second "C"</p> <p>and for a corresponding fix to the <code>OFFSET</code> version you can use</p> <p><code>=VLOOKUP($B6,OFFSET(C30,0,C4):OFFSET(D36,0,C4),2,0)</code></p>