Hello,
Need some help with a formula, I have a workbook with column A row 1 that is blank and I want to enter a part number in A1 (example 12345) and in B1 have a weight entered from sheet 2.
Sheet 2 would have a list of part numbers in column A 1 thru A 60 and in column B 1 thru 60 would have a weight adjacent to each part number (example 2.5 lb).
When a person enters one of these part numbers from sheet 2 into A1 on sheet 1 the weight matching that part number will auto populate in B1 sheet 1.
Thanks for any help you can provide.
Bikeman
Bookmarks