Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |