Thread: green mark in the top left corner of cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default green mark in the top left corner of cells
It is not the error-checking arrow that is screwing up your VLOOKUP

The error-checking indicates inconsistent data like number stored as text.

See ToolsOptionsError Checking for options.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 14:24:01 -0700, leo wrote:

whne i import data i sometimes get a green mark in the top left corner. This
screws up matching when doing a vlookup. how do i get rid of the green mark?

thx

Reply With QuoteReply With Quote