Hello All,
I"m a bity of a rookie user of Excel, and i'm trying to see if is possible to do the following:
I have two spreadsheets, one has every part number and price available to us. The other has all the part numbers we currently have in stock and quantitys, but not pricing.
I want to be able to have a formula to take one part number from the spreadsheet with my quantities, and have it find the matching number on the priced sheet. Then have it take that price and put it in the sheet without pricing.
Is this possible?
THank you in advance
T.J