Gilbert was right! I had to force both worksheets into a Value format using:
=VALUE(A2)
on the referenced worksheet. Copied this all the way down

and then using
=VLOOKUP(VALUE(A2),SAP!B$2:C$2319,2,FALSE)
on the one I needed the values

Which I think will also help me solve an earlier issue I had getting the
ss#'s in the first place. Thanks!
--
Excel isnt just a program its a metaphor for life. Sometimes it''s easy and
boring.. sometimes it''s a little challenging and great.. then there are days
it will drive you absolutely INSANE.


"Gilbert" wrote:

Make sure the format is the same on both worksheets and also the worksheet
that you are getting the information from must be sorted ascending. I hope
it helps.

"Katerinia" wrote:

Simply, i have a worksheet that has one row of ss#'s and next column datat
that refers to that ss#.
In a larger worksheet, I have the column ss#, and i need the data from the
first worksheet to be in this one.... for some reason.. i cant get vlookup to
work.. Its over 8K rows.
--
Excel isnt just a program its a metaphor for life. Sometimes it''s easy and
boring.. sometimes it''s a little challenging and great.. then there are days
it will drive you absolutely INSANE.