# Return Single Value Based on Multiple Criteria

1. ## Return Single Value Based on Multiple Criteria

Hi. I've been searching lots of forums all morning and cannot find a solution to my problem.

I'm trying to have a formula check a single number against multiple criteria and return a single solution.

Here is the data:
Check if this number "61108" is between the numbers in columns A and B, and then return the % in column C:

- 50,000 15%
50,001 75,000 25%
75,001 100,000 34%
100,001 335,000 39%
335,001 10,000,000 34%
10,000,001 15,000,000 35%
15,000,001 18,333,333 38%
18,333,334 35%

I hope this makes sense.

2. ## Re: Return Single Value Based on Multiple Criteria

If your table is in A1 to C8 and you want to check for a value in D1, then try:

=LOOKUP(D1,A1:C8)

3. ## Re: Return Single Value Based on Multiple Criteria

A lookup table only needs the START of each range of values, the start of the next range implicitly shows the end of the previous range. Understand?

So, a lookup table would be:
``Please Login or Register  to view this content.``

4. ## Re: Return Single Value Based on Multiple Criteria

Thank you!! Such a simple solution and I just couldn't find it anywhere.

I appreciate your help.

5. ## Re: Return Single Value Based on Multiple Criteria

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1