First post and First Question!

[SuchHelp_MuchThanks]

Hey,

Just want to say, this is a great community as I've constantly been coming here to read other people advice but I finally have a question for myself!

Please bare with me as I'm not too sure on the best way to get this into words. I'm currently creating a brand new fancy spreadsheet but using data from an old one. I've moved across all the raw data into a different sheet into the new work book but all the information is everywhere. Is there an equation to automatically import data with matching names for example? I want to bring emails and addresses from the raw data and have it automatically put in the new spreadsheet matching the names. One is in alphabetical order and the other is in order of order date. So I can't just copy and paste. I currently have to do it one by one which will take me a very long time. Is there a way to bring over John Bloggs email and address and have it paste in each of John Bloggs orders automatically?

Sorry if this is a little convoluted!

Thanks

 

[dispelthemyth]

If you share your data as is and then a demonstration of how you want it to look you will get better answers

 

[shyy]

Sounds like you need a VLOOKUP

=VLOOKUP(lookupvalue,range,# of column,FALSE)

Excel 2010
	I	J	K	L	M	N
1	john brigger	john.brigger@aol.com			john brigger	john.brigger@aol.com
2	john doe	john.doe@aol.com
3	jane mary	jane.mary@aol.com
Sheet7

Cell Formulas
Range	Formula
N1	=VLOOKUP(M1,$I$1:$J$3,2,FALSE)

 

[SuchHelp_MuchThanks]

How do you mean share data as is? I can't share the actual spreadsheets due to all the data being confidential information.

But lets say that I have john bloggs details as part of my original raw data. It appears in a simple spreadsheet which is nothing but names in alphabetical order with their emails and addresses. I've been making a new spreadsheet of every single order but the names are order of date. Some appear more than once depending if they ordered more than once. How could I tell excel to import the data of john bloggs' email and address and have it automatically inserted into the appropriate cells of every john bloggs entry in my order sheet? Does that make sense?

 

[SuchHelp_MuchThanks]

Sounds like you need a VLOOKUP

=VLOOKUP(lookupvalue,range,# of column,FALSE)

Excel 2010

	I	J	K	L	M	N
1	john brigger	john.brigger@aol.com			john brigger	john.brigger@aol.com
2	john doe	john.doe@aol.com
3	jane mary	jane.mary@aol.com

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet7​

Worksheet Formulas Cell Formula N1 =VLOOKUP(M1,$I$1:$J$3,2,FALSE) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you, that looks like what I'm after. I won't be able to try this until tomorrow but I'll give it a shot then. I'll give this a bump if I'm still stuck and come up with a better example of what I'm after.

 

[SuchHelp_MuchThanks]

Sounds like you need a VLOOKUP

=VLOOKUP(lookupvalue,range,# of column,FALSE)

Excel 2010

	I	J	K	L	M	N
1	john brigger	john.brigger@aol.com			john brigger	john.brigger@aol.com
2	john doe	john.doe@aol.com
3	jane mary	jane.mary@aol.com

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet7​

Worksheet Formulas Cell Formula N1 =VLOOKUP(M1,$I$1:$J$3,2,FALSE) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

This worked PERFECTLY! Thank you so much.

 

[shyy]

Glad it worked out and thanks for feedback

Another alternative is using INDEX & MATCH

=INDEX($J$1:$J$3,MATCH(M1,$I$1:$I$3,1))