Forum Discussion
How to Remove green triangles from cells
To whom it may concern: how do I remove the green triangles on the left hand upper corner in cells?
Thank you for your help!
Suzan
4 Replies
- The green triangle is an indication that there is a potential error is your formula... Kindly upload the file (if possible) to solve the problem for you
Two ways
You may select such cells, expand drop-down menu on appeared icon and ignore errors
Second, you may always ignore some types of alerts changing the settings
but I'd not recommend
Thank you for this information. However, after I did what you suggested, I still was not able to perform a VLookup. Do you have any ideas?
Suzan, as variant lookup value could be the number saved as text, and in lookup array you have numbers (or opposite). That is most common reason for appearing of green triangle (but not only) which indicates that could be an error. If you are sure you have no error, you ignore it. If you see that's real error you may correct it from the same menu, in our example as
or by editing the value/formula in formula bar or by other way. Alternatively you may modify VLOOKUP() formula to use same types for lookup value and the array, e.g. converting text to number by double dash in front or by VALUE().
But above is only the guess, these could be another reasons.
