Forum Discussion
How to Remove green triangles from cells
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.