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?