I apologize if the header is not correct. I currently have a spreadsheet where I enter a part number and quantity and it uses a vlookup and match formula to pull a price from a 2nd tab that has various pricing brackets. My customer would like to enter a part number and price and have a quantity they need to order displayed. Currently I can not post the spreadsheet for confidentiality reasons but if you guys think it can be done I can remove info and post a dummy version for your help. Does anyone think this can be done? Also I do not want to change the format of the original spreadsheet because than there are 2 spreadsheets that will need to be maintained.
Bookmarks