VBA MS excel flist of number to find if it falls between a list of numbers

Question

Hi,

I have a list of numbers as below. I have to go through all the numbers listed below

and try to see if they are between the new start and new stop and the answer would be the code

ex 447797704123000 would be E

452591880100000 - Not found

etc

Answer 1

Hi @S.Vella

Do you want to try a formula?

According to your description and the sample, I make a simple sample like following image.

Then please enter formula =IFERROR(INDEX($C$2:$C$6,MAX(IF(E2<IF(E2>$A$2:$A$6,$B$2:$B$6,-1),ROW($B$2:$B$6)-1,-1)),1),"Not Found") in F2.

Press Ctrl + Shift + Enter to make this formula as an arry formula.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---