I have an Excel spreadsheet with two tabs. Sheet 1 has part information for this month such as part number, description, price, etc. Sheet 2 has a complete list of part numbers in column A and commission percentages in column B.
When I enter a part number in sheet 1 I want it to automatically fill in the percentage based on the source info in sheet two. So I will provide part numbers in sheet one each month and the commission percentage will be filled in automatically based on the info in sheet 2.