<div>
Hi,<br />
<br />
pls try<br />

<pre><code class="code-1 nolinks" id="code-20-42065254-1"><span>=IFERROR(VLOOKUP($K$5;Travbanor!$B$6:$S$100;15;FALSE);&quot;&quot;)</span>
</code></pre>
Regards
</div>


<div>
Do not use IFERROR until you are sure that the formula is entered correctly. This will hide errors that may point you to why the formula is not working.
</div>


<div>
Ok, I understand now: last column for the lookup must be specified in the array. Thanks!
</div>


<div>
If you are always going to use two columns and those columns are both known, ie lookup column and result column, you can use the LOOKUP function:<br />
<br />
Syntax:<br />
=LOOKUP(LookUpValue,LookUp<wbr />Range,Resu<wbr />ltRange)<br />
<br />
In your scenario:<br />
<br />
=LOOKUP($K$5;Travbanor!$B$<wbr />6:$B$100;T<wbr />ravbanor!$<wbr />P$6:$P$100<wbr />)<br />
<br />
Advantage with this is that if a column gets inserted between B &amp;&nbsp;P the reference to P would shift whereas with standard VLOOKUP the offset value would not adjust.<br />
<br />
Thanks<br />
Rob H
</div>


<div>
<div class="content wysiwyg-content">
I have this VLOOKUP formula in my Excel:<br />
<br />
=IFERROR(VLOOKUP($K$5;Trav<wbr />banor!$B$6<wbr />:$M$100;12<wbr />;FALSE);&quot;&quot;<wbr />)<br />
<br />
And it finds the value 1.7 in column 12 from the left without problems.<br />
<br />
Then I change to column 15 (otherwise everything else is exactly the same):<br />
<br />
=IFERROR(VLOOKUP($K$5;Trav<wbr />banor!$B$6<wbr />:$M$100;15<wbr />;FALSE);&quot;&quot;<wbr />)<br />
<br />
But now Excel does not find the value 1000 (even though it's there)! Why? And what needs to be changed so I get the value 1000 retrieved?
</div>
</div>


I have this VLOOKUP formula in my Excel:

=IFERROR(VLOOKUP($K$5;Travbanor!$B$6:$M$100;12;FALSE);"")

And it finds the value 1.7 in column 12 from the left without problems.

Then I change to column 15 (otherwise everything else is exactly the same):

=IFERROR(VLOOKUP($K$5;Travbanor!$B$6:$M$100;15;FALSE);"")

But now Excel does not find the value 1000 (even though it's there)! Why? And what needs to be changed so I get the value 1000 retrieved?

Why doesn't my VLOOKUP formula work even though it work for another post three columns to the left?

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.