- To post as a guest, your comment is unpublished.· 1 months agoYou will need to use $ for the lookup cells valuesSo if you have a column of values you want to look up you would modify the formula as follows:=VLOOKUP(E2,$A$2:$C$8,3, TRUE)E2 would change as you fill down but the table you are looking up from will remain constant
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.
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?
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 3 months agoThe value works on the first cell. How do you do it for the entire column cell?
- To post as a guest, your comment is unpublished.· 1 years agoawesome, thanks!
- To post as a guest, your comment is unpublished.· 2 years agoDoesn't work. if only it was that simple, wouldn't need to be googling for this
- To post as a guest, your comment is unpublished.· 1 years agoIt obviously does. Instead of whining and trying to be a smartass about it, you could have at least tried it out.
- To post as a guest, your comment is unpublished.· 1 years agoIt does. Try it out before rudely complaining, simple as that.