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