Good Morning Everyone,
So, I have a sheet with a list of Part Numbers with some data to the right of it (3 different columns), and a empty NEW sheet
Basically, on the NEW sheet I made, I want somebody to be able to type a part number into a specified column and have excel match what part number that was typed in with the list of part numbers already made, and if there is a match, then autofill the data that's on the 3 columns on the right into the new sheet next to the part number they typed in.
Example:
They type in:
W51501-01
(EXCEL checks other sheet to see if the part number is on the list)
Other List Data:
W51501-01 FPZ 5 1000
(EXCEL finds exact match, with W51501-01)
(EXCEL then takes the data of the columns next to the part number and autofills it next to the part number they typed in on the other sheet, also in 3 different columns)
THE data excel would take:
FPZ 5 1000
End result on NEW Sheet (sheet they typed part number into):
W51501-01.............FPZ...............5............1000
(they typed in) (Autofilled) (Autofilled) (Autofilled)
Thanks for the help!
Bookmarks