CODEWITHSUNDEEP
excelvbaformulas
Patrick Bender
Patrick Bender

Reputation: 467

Excel Find if value is within interval and return interval category

I have a lot of numbers in column A. In column B I want to be able to retrieve the right category found in column D based on the interval specified in column E-F. VBA or formula would help a lot!

You can see the end result with a few ranges and values in the attatched picture.

End result

Upvotes: 0

Views: 3839

Answers (1)

Scott Craner
Scott Craner

Reputation: 152495

As stated a simple INDEX/MATCH will do it:

=INDEX(D:D,MATCH(A2,E:E))

Upvotes: 2

Related Questions