First post and First Question!

SuchHelp_MuchThanks

New Member
Joined
Jan 7, 2014
Messages
16
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 :)
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

dispelthemyth

Well-known Member
Joined
Mar 16, 2006
Messages
654
If you share your data as is and then a demonstration of how you want it to look you will get better answers
 

shyy

Well-known Member
Joined
Nov 6, 2008
Messages
1,484
Sounds like you need a VLOOKUP

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

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">john brigger</td><td style=";">john.brigger@aol.com</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">john brigger</td><td style=";">john.brigger@aol.com</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">john doe</td><td style=";">john.doe@aol.com</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">jane mary</td><td style=";">jane.mary@aol.com</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet7</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">N1</th><td style="text-align:left">=VLOOKUP(<font color="Blue">M1,$I$1:$J$3,2,FALSE</font>)</td></tr></tbody></table></td></tr></table><br />
 
Last edited:

SuchHelp_MuchThanks

New Member
Joined
Jan 7, 2014
Messages
16
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

New Member
Joined
Jan 7, 2014
Messages
16

ADVERTISEMENT

Sounds like you need a VLOOKUP

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

Excel 2010
IJKLMN
1john briggerjohn.brigger@aol.comjohn briggerjohn.brigger@aol.com
2john doejohn.doe@aol.com
3jane maryjane.mary@aol.com

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

Worksheet Formulas
CellFormula
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

New Member
Joined
Jan 7, 2014
Messages
16
Sounds like you need a VLOOKUP

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

Excel 2010
IJKLMN
1john briggerjohn.brigger@aol.comjohn briggerjohn.brigger@aol.com
2john doejohn.doe@aol.com
3jane maryjane.mary@aol.com

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

Worksheet Formulas
CellFormula
N1=VLOOKUP(M1,$I$1:$J$3,2,FALSE)

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

This worked PERFECTLY! Thank you so much.
 

shyy

Well-known Member
Joined
Nov 6, 2008
Messages
1,484
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))
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,594
Messages
5,637,299
Members
416,963
Latest member
zazama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top