**Question description:**

*This user has given permission to use the problem statement for this blog.*

I'm looking to create a formula that based on a master order list will take data and bring into another sheet, like the customers name, and other fields. So what I have is an Invoice Number (ie. 18-001) and I want to enter that 18-001 onto a billing sheet and have many data boxes lookup who the customer was, what was performed and what rate applies. All of this is populated into the master order list, how can I make it automatically update from that list onto another sheet?

Solved by D. D. in 33 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
14/07/2018 - 06:56

Welcome to ExcelChat!

User
14/07/2018 - 06:56

thanks

Excelchat Expert
14/07/2018 - 06:56

Will you provide the data based on which we will work?

User
14/07/2018 - 06:57

I have a file

User
14/07/2018 - 06:57

how do I bring it up?

Excelchat Expert
14/07/2018 - 06:57

You can press the paper clip icon

Excelchat Expert
14/07/2018 - 06:57

and attach it

User
14/07/2018 - 06:58

There is no paper clip

Excelchat Expert
14/07/2018 - 06:59

Okay, let's do it on the data which you put in the document here

Excelchat Expert
14/07/2018 - 07:00

You can contact the support later to determine why you can't attach the files in the chat, if you wish of course

Excelchat Expert
14/07/2018 - 07:01

I can see your data on Sheet1, where do you want to have the solution?

User
14/07/2018 - 07:01

Okay now everything we need is there

User
14/07/2018 - 07:01

I want to populate sheet 2 automatically based on sheet 1 info

Excelchat Expert
14/07/2018 - 07:02

In which place should it appear?

User
14/07/2018 - 07:05

Based on sheet 1's data in column A, I'd like to input the number (say 18-102) into sheet 2 and then sheet 2 would populate fields based on what is in sheet 1. But there is also an address / customer info to find and put into sheet 2 as well, which is on different tabs. I'm not sure if a different work sheet for each customer info is easier or makes things more complicated

Excelchat Expert
14/07/2018 - 07:06

" which is on different tabs. I'm not sure if a different work sheet for each customer info is easier or makes things more complicated" - we won't be able to autopopulate this info, all information has to have the same structure

Excelchat Expert
14/07/2018 - 07:06

But we can get info from sheet1

Excelchat Expert
14/07/2018 - 07:07

I will make the solution in B37

User
14/07/2018 - 07:08

What I'm thinking is that on sheet 2 in E4, I fill out the 18-102 and then I want to lookup in sheet 1 who the customer is and insert that info in B9

Excelchat Expert
14/07/2018 - 07:09

So you need only customers name? Of all the cells which are available? And you want to insert them down?

Excelchat Expert
14/07/2018 - 07:09

Could you show the result on one example please?

Excelchat Expert
14/07/2018 - 07:09

Like if you entered 18-102

User
14/07/2018 - 07:10

If I enter 18-102 into E4, I would like the following to happen.

Excelchat Expert
14/07/2018 - 07:11

Please enter it in E4 and show what we should receive

User
14/07/2018 - 07:12

In B9 the customers name would populate, which is sheet 1 column C, I also want the C17 in sheet 2 to be populated from the column D in the row that 18-102 is.

Excelchat Expert
14/07/2018 - 07:13

When you see the pop up, please extend the session

User
14/07/2018 - 07:14

Did you get what I want to happen?

Excelchat Expert
14/07/2018 - 07:15

Yes, I started working

User
14/07/2018 - 07:22

Come up with anything?

Excelchat Expert
14/07/2018 - 07:23

Almost there

Excelchat Expert
14/07/2018 - 07:24

Yes, I have completed what you asked

Excelchat Expert
14/07/2018 - 07:24

In B9 we used the following formula

Excelchat Expert
14/07/2018 - 07:24

=vlookup($E$4,Sheet1!A:C,3,0)

Excelchat Expert
14/07/2018 - 07:25

So we took the E4 value and searched the 3 column of it in sheet1

Excelchat Expert
14/07/2018 - 07:25

For C17, we used the same formula, but slightly modified the range, because these time we need 4th column of data from Sheet1

Excelchat Expert
14/07/2018 - 07:25

=vlookup($E$4,Sheet1!A:D,4,0)

User
14/07/2018 - 07:27

And I can make different files just by adding the file name into the v lookup coomand

Excelchat Expert
14/07/2018 - 07:28

You can auto populate all the data that you wish just by changing the reference addresses in vlookup funtion

User
14/07/2018 - 07:28

Awesome thanks

Excelchat Expert
14/07/2018 - 07:29

You are welcome!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*