Thanks RD.

I thought about that "at least 2 columns" statement after I posted and did not
correct it.

Pure sloth.

Gord

On Mon, 13 Jun 2005 16:49:46 -0700, "RagDyer" wrote:

Actually Gord, although I'd prefer MATCH, which would give a location, you
could use it with one column, if say, you were checking to see if something
did exist in a column:

=VLOOKUP(B1,A:A,1,0)