VLOOKUP() without the "dashes". For example, if E1 thru F4 contains:

123-45-6789 Jim
123-45-6790 Joe
123-45-6795 John
123-45-6799 Janet

then

=VLOOKUP(123456795,E1:F4,2) displays John
--
Gary''s Student - gsnu200850


"norie" wrote:

I formatted cells as SS# but the formula bar does not reconize the dashed
there for I am unable to do a Vlookup from it. What do I need to do to get
the formula bar to reconize the dashed. What can I do otherwise to get the
Vlook up to work.
Thanks,