Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! Lookup
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! Lookup
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! Lookup
I agree with checking to make sure that the SS# columns are formatted the
same (that one isn't numbers formatted to display as SS type entries with dashes, while the other may be text). It would have helped if Katerinia had posted the formula she is using, but it isn't absolutely necessary that the SS#s be in sequence if the VLOOKUP() is constructed as: =VLOOKUP(A2,'Source Sheet'!$A$2:$B$1000,2,FALSE) The 'FALSE' parameter will allow it to work with an unsorted list. "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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! Lookup
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |