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.
