Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to created an excel spreadsheet that will remember all of our company part numbers so I will be able to fill out a Sales Order and it will auto fill the information about the part if I enter the part number
Solved by M. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/08/2018 - 02:41
HI
User
30/08/2018 - 02:41
Hello
Excelchat Expert
30/08/2018 - 02:42
Do you have any excel to begin with or it is completely from the scratch
User
30/08/2018 - 02:42
I am working on microsoft 365
Excelchat Expert
30/08/2018 - 02:43
ok
Excelchat Expert
30/08/2018 - 02:44
most of the functionalities are same ..
Excelchat Expert
30/08/2018 - 02:44
but if you have the excel you can share here
Excelchat Expert
30/08/2018 - 02:45
Do you have an excel in microsoft 365
Excelchat Expert
30/08/2018 - 02:45
or are we starting from the start
Excelchat Expert
30/08/2018 - 02:50
In the preview i have created a sample sheet
Excelchat Expert
30/08/2018 - 02:50
so you can have a sheet with information related to Parts
Excelchat Expert
30/08/2018 - 02:50
the description the price etc.. in your sales order sheet as soon as you enter the part number all the information will be automatically populated
Excelchat Expert
30/08/2018 - 02:51
Please verify the solution
User
30/08/2018 - 02:58
Sorry for the late response
Excelchat Expert
30/08/2018 - 02:58
Hi
Excelchat Expert
30/08/2018 - 02:59
can you see the excel in the preview?
User
30/08/2018 - 02:59
I'm needing help with putting part numbers in a sheet and having them auto-fill in another sheet
Excelchat Expert
30/08/2018 - 02:59
If you share the excel i can build the solution based on the format of your excel
User
30/08/2018 - 03:00
It's not allowing me to share
[Uploaded an Excel file]
User
30/08/2018 - 03:00
Nvm there it goes
User
30/08/2018 - 03:00
I am needing the part numbers in sheet two to auto fill in the sales order
Excelchat Expert
30/08/2018 - 03:00
ok give me few min to work onthe formula
User
30/08/2018 - 03:01
but only when I type the part numbers in, as every week sales order are different
Excelchat Expert
30/08/2018 - 03:01
ok if number is blank all the rest of the row is also blank right
User
30/08/2018 - 03:01
Correct
Excelchat Expert
30/08/2018 - 03:02
i only see 1 sheet ORDER FORM
User
30/08/2018 - 03:02
Hold on let me save and resend
Excelchat Expert
30/08/2018 - 03:02
sure
User
30/08/2018 - 03:02
How about now?
[Uploaded an Excel file]
Excelchat Expert
30/08/2018 - 03:03
yes see it
User
30/08/2018 - 03:03
Okay great!
Excelchat Expert
30/08/2018 - 03:03
so when you enter number in item all the values will appear
User
30/08/2018 - 03:03
There are over 1000 parts I just haven't put them in there yet
User
30/08/2018 - 03:04
NO, I would like them to appear lol
User
30/08/2018 - 03:04
I would enter the quantity as each week is different, but I would like for the rest to autofill after I type in the Item#
Excelchat Expert
30/08/2018 - 03:05
quantities and pieces you would enter got it
User
30/08/2018 - 03:05
Yes, perfect!
Excelchat Expert
30/08/2018 - 03:10
here
[Uploaded an Excel file]
Excelchat Expert
30/08/2018 - 03:10
added few samples in Parts sheet
User
30/08/2018 - 03:11
It's taking some time to download
User
30/08/2018 - 03:11
Would you be able to tell me how you did it for future reference
Excelchat Expert
30/08/2018 - 03:11
yes its a smiple Vlookup function
Excelchat Expert
30/08/2018 - 03:11
the formula for description is =IFERROR(VLOOKUP($B12,Parts!$A$2:$C$65536,2,FALSE),"")
User
30/08/2018 - 03:12
And where do I place that formula?
Excelchat Expert
30/08/2018 - 03:12
enter this formula in C12 then just drag it
Excelchat Expert
30/08/2018 - 03:12
it will auto update the references
Excelchat Expert
30/08/2018 - 03:13
then for Rough Width & Length =IFERROR(VLOOKUP($B12,Parts!$A$2:$C$65536,3,FALSE),"")
Excelchat Expert
30/08/2018 - 03:14
can you see the excel on the right
Excelchat Expert
30/08/2018 - 03:14
in the preview
Excelchat Expert
30/08/2018 - 03:15
it has the formula
Excelchat Expert
30/08/2018 - 03:15
you are there
Excelchat Expert
30/08/2018 - 03:18
Please verify the solution .. we have 3 min left
User
30/08/2018 - 03:18
for some reason it's not working
Excelchat Expert
30/08/2018 - 03:18
1 min
Excelchat Expert
30/08/2018 - 03:19
in microsoft 365?
Excelchat Expert
30/08/2018 - 03:19
do you see error
Excelchat Expert
30/08/2018 - 03:21
Please could you tell me what you see can you send a screen shot or soemthing
Excelchat Expert
30/08/2018 - 03:21
it seems to be working in my excel and the privew window as well
Excelchat Expert
30/08/2018 - 03:31
Hello this is the last 10 min remaining
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.
