# Excel forum within a range [Solved]

Ask a question Gerberreinette 3Posts Friday March 4, 2016Registration date May 11, 2017 Last seen - Last answered on Apr 24, 2017 at 08:45 AM by Gerberreinette
Good day

I am looking for a formula PLEASE.

Example

Column A, Column B, Column C, Column D, Column E, Column F
No, Start, End, Used number, Asset , Result,
1, 10000, 999999, 10327, 2005825, 3
2, 1000000, 1999999, 1000168, 2006045, 3
3, 2000000, 2999999, 2006743, 2006064, 3
4, 3000000, 3999999, 3124118, 2006065, 3
5, 4000000, 4999999, 4002708, 2006066, 3
6, 5000000, 5999999, 5008181, 2006067, 3

The formula should tell me in what range the asset falls. All assets shown above falls within the range next to No.3. The formula should show a 3 in the Result column

Thank you so much in advance for taking the time to help and for your answers - this is much appreciated.

Regards
+0
Gerberreinette, Good morning.

Try to use:
F2 -->

=INDEX(\$A\$2:\$A\$7,MATCH(VLOOKUP(E2,\$B\$2:\$B\$7,1,TRUE),\$B\$2:\$B\$7,0))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Gerberreinette-
Thank you so much for your assistance. It works 100%, I really appreciate.