Excel - LOOKUP Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc