<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
<br />
How can i get the value 1 row below the cell that contains the value in this Lookup: <br />
=VLOOKUP($B2,sheet1!$B:$L,<wbr />2,FALSE)<br />
<br />
Thanks, <br />
<br />
Tom
</div>
</div>


Hi Experts, 

How can i get the value 1 row below the cell that contains the value in this Lookup: 
=VLOOKUP($B2,sheet1!$B:$L,2,FALSE)

Thanks, 

Tom

Vlookup + offset problem

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.