How to return a value if a given value exists in a certain range in Excel?
As the left screenshot shown, if a given number 5 is in a certain number range, how to return the value in the adjacent cell. The formula method in this article can help you achieve it.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
Please apply the following formula to return a value if a given value exists in a certain range in Excel.
1. Select a blank cell, enter formula =VLOOKUP(E2,A2:C8,3, TRUE) into the Formula Bar and then press the Enter key. See screenshot:
You can see the given number 5 is in the number range 4-6, then the corresponding value Addin 012 in the adjacent cell is populated into the selected cell immediately as above screenshot showed.
Note: In the formula, E2 is the cell contains the given number, A2:C8 contains the number range and the value you will return based on the given number, and number 3 means that the value you will return locates in the third column of range A2:C8. Please change them based on your need.
- How to vlookup value and return true or false / yes or no in Excel?
- How to vlookup return value in adjacent or next cell in Excel?
- How to return value in another cell if a cell contains certain text in Excel?