Here is what I'm trying to figure out for the formula. I have two worksheets (Master Sales and Inventory)
Inventory has columns
Item Description Vendor Item Number Invoice# Purchased Price Qty Inventory Balance
Master Sales has columns
Item Number Item Description Purchased Price Shipping Costs Etc . . . . .
I want to copy the purchase price from inventory and copy to the master sales to input the price that corresponds to the item description. What would the formula be for this. Please help, thank you.
Bookmarks