A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how can I connect data in cell C to data in cell D?



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2006, 12:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old March 8th, 2006, 04:27 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old March 8th, 2006, 06:47 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent date/scheduling calc needed jct Worksheet Functions 3 February 24th, 2006 02: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 08:16 PM


All times are GMT +1. The time now is 04:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.