If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can I connect data in cell C to data in cell D?
I have allot of data, for example cell A is gender, cell B is year of birth
and cell C is respondentnumber, cell D is also respondent number and cell E is kids yes/no. Cell C and D are both respondentnumbers, but they are both from different datasources, I need to connect the right data from both sources to eachother. In the end I have to know for each respondent what its corresponding gender, year of birth and if they have kids. |
#2
|
|||
|
|||
how can I connect data in cell C to data in cell D?
I think we need to be told more about C and D data
A B C D E Male 1983 3333 4444 Yes Female 1985 7777 8888 No So what do you want to do? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Angel82" wrote in message ... I have allot of data, for example cell A is gender, cell B is year of birth and cell C is respondentnumber, cell D is also respondent number and cell E is kids yes/no. Cell C and D are both respondentnumbers, but they are both from different datasources, I need to connect the right data from both sources to eachother. In the end I have to know for each respondent what its corresponding gender, year of birth and if they have kids. |
#3
|
|||
|
|||
how can I connect data in cell C to data in cell D?
If all of the numbers in C are also found in D, and D has no duplicates, you
could use some lookups. Move D and E to F and G. Sort the columns F and G in ascending order by column F. I assume that the lookup data are now in F2:G101 (assuming row 1 contains labels). Enter this formula in cell D2: =VLOOKUP(C2,$F$2:$G$101,2,FALSE) What this does is looks for the number in C2 in the first column of $F$2:$G$101, and returns the value in column 2 of $F$2:$G$101. FALSE means return exact matches, and if an exact match isn't found, return #N/A. If you had used TRUE, you would get a close match: say you were looking up 5 from C2, and column F contained 2,3,4, no 5, and other higher numbers. The formula would return the value next to the cell containing 4, the closest number to 5 that didn't exceed 5. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Angel82" wrote in message ... I have allot of data, for example cell A is gender, cell B is year of birth and cell C is respondentnumber, cell D is also respondent number and cell E is kids yes/no. Cell C and D are both respondentnumbers, but they are both from different datasources, I need to connect the right data from both sources to eachother. In the end I have to know for each respondent what its corresponding gender, year of birth and if they have kids. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent date/scheduling calc needed | jct | Worksheet Functions | 3 | February 24th, 2006 01:36 AM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Input cell reference is not valid (One Variable Data Table) | Dottore | Worksheet Functions | 9 | September 1st, 2005 03:05 PM |
copying cell names | Al | General Discussion | 3 | August 11th, 2005 03:01 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |