If your threshold values are in ascending order, you can use INDEX/MATCH with a "Match Type" of 1 on the threshold values to return the proper category. In the attached sample, the threshold table is in G2:H6, the company revenue is in B2, and the lookup in C2 is:
=INDEX($H$2:$H$6,MATCH($B2,$G$2:$G$6,1))
Fill down for other companies. Take a look at the attachment to see if it'll do the trick:
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks