<div>
Or actually simpler:<br />
<br />
=MATCH(E2,$A$2:$A$6)<br />
<br />
since they are listed in ascending order and no gaps in ranges.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a range such as this<br />
<br />
ID start &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID End<br />
1200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1299<br />
1300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1399<br />
1400 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1499<br />
1500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1599<br />
1600 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1699<br />
<br />
Now I have an ID say 1378<br />
<br />
How do I lookup this id in the range above using formulas?<br />
<br />
Thanks!
</div>
</div>


Hi,

I have a range such as this

ID start          ID End
1200              1299
1300              1399
1400              1499
1500              1599
1600              1699

Now I have an ID say 1378

How do I lookup this id in the range above using formulas?

Thanks!

Range value lookup

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