# First post and First Question!

#### SuchHelp_MuchThanks

##### New Member
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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
If you share your data as is and then a demonstration of how you want it to look you will get better answers

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
Sheet7
Cell Formulas
RangeFormula
N1=VLOOKUP(M1,\$I\$1:\$J\$3,2,FALSE)

Last edited:
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?

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

</tbody>
Sheet7

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

</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.

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

</tbody>
Sheet7

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

</tbody>

<tbody>
</tbody>

This worked PERFECTLY! Thank you so much.

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:

Replies
5
Views
274
Replies
3
Views
351
Legacy 143009
L
Replies
14
Views
2K
Replies
1
Views
321
Replies
2
Views
536

1,211,710
Messages
6,103,454
Members
447,866
Latest member
bowers261

### 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.

### Which adblocker are you using?

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

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