Q: Why can’t I find any result in Sheets using the VLOOKUP function?
Possible cause 1: No matches are found in the search scope
When there are no matches for your search, Sheets will prompt no results are found.
Possible cause 2: The value you search for is in a cell with a green triangle in the upper-left corner, and the value in the search scope is a general number
Although numbers in general cells and in cells with a green triangle look the same, the former is actually a digit, while the latter is text. That's why you can't find matches using the VLOOKUP function. Click here to learn more about cells with a green triangle.
You can unify content properties of cells in two ways:
- 1.The number of digits in a cell with a green triangle is smaller: Format cells as numbers, that is, without a green triangle in the upper-left corner, and then you can find results with the VLOOKUP function.
- 2.The number of digits in a cell with a green triangle is greater: If you convert the value to a number, the precision may be compromised. For example, if you convert the value 12345678987654321 to a number, the value may change to 12345678987654300. We recommend you convert all values to text (with a green triangle) to ensure data precision and validity of the VLOOKUP function.
👍 If article has been helpful, remember to scroll down to the bottom of the article and click Like on the left.