Both have the lenght of 14 characters

"Sandy Mann" wrote:

I would think that the reason that reason that you are having trouble is
that the lookup value is not being found because it has an invisible
charcter at one end of the name.

Try using the formula =Len(Cell reference that should match your VLOOKUP)
and see if it returns a different number than the number of charcters that
seem to be in the cell.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"caldog" wrote in message
...
Thanks folks for the information I thought I knew how to do a vlookup, but
this one has me stumped.

My formula is the following: =VLOOKUP("Rick",'Sheet A'!L6:O47,4), which
if
I am not mistaken is just like what you folks are telling what to do. But
every time this formula is returning a #N/A. The columns that have the
lookup and the corresponding column have been checked and both are text
columns. I also just before writing this checked that my number columns
that
they were in the number format, and they are. So I am at a lost as to
what
is causing the #N/A to appear. A thought has just struck me, if I have
some
of the names but not all of my names hyphened, would that cause the #N/A
to
appear?