The green triangle is probably an error/alert message. With this example,
probably stating the the data entered into the field is entered as Text. One
way to get around this is to add a VALUE(<cell) function to the cell which
you are attempting to lookup as a non-text. The VALUE function will force
the cell to be pulled as a Number.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Mike" wrote:

A text cell value = 12345678 with a green triangle in the left upper corner
of the cell will not match a text cell value = 12345678 with no green
triangle when doing a VLOOKUP.
When is the green triangle inserted and how can it be managed.