# Excel forum within a range

Solved/Closed
Gerberreinette Posts 14 Registration date Friday March 4, 2016 Status Member Last seen July 31, 2023 - Apr 21, 2017 at 08:09 AM
Gerberreinette - Apr 24, 2017 at 08:45 AM
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
Related:

## 1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 21, 2017 at 10:55 AM
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
Apr 24, 2017 at 08:45 AM
Thank you so much for your assistance. It works 100%, I really appreciate.