Report

Excel forum within a range [Solved]

Ask a question Gerberreinette 2Posts Friday March 4, 2016Registration date April 21, 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
See more 
Helpful
+0
plus moins
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.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!