# Get instant live expert help on I need help with purchase order template excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Need help adding to a formula in Excel on Purchase Order - Copy and Paste tab.
Solved by F. S. in 16 mins
I have data within an excel spreadsheet where the plant/mat field repeats, however the purchase order date and net order price do not repeat. I need to figure out a formula to determine if the purchase order date is older and the net order price is greater based on the same plant/mat. For instance, material 273646 purchase order date of 7/10/2017 and net order price is greater than the 4/23/2018 and the 4/23//2018 order price Material Plant Plant/Mat Purchase Order Date Net Order Price Currency Price Unit Order Price Unit 273646 1024 1024273646 7/10/2017 116.94000 USDN 1 EA 273646 1024 1024273646 4/23/2018 115.85960 USDN 1 EA
Solved by O. A. in 26 mins
I'm trying to create a purchase order template. I use Excel for Mac. I need to have a searchable combo box (or any other suggestion), linked to a list with 1000 clients. I'd like to be able to click on a cell or the combo box and be able to write the first 2 or 3 letters of my client's name and find it, and not have to scroll down a thousand names. The list with names is on a different sheet and not on the first one, which is the interface of the purchase order. Once I select a name, I need other cells to auto populate with address, e-mail and telephone.
Solved by G. S. in 24 mins
I need a corrected formula for: =Purchase!A5/Purchase!C10*Purchase!A6
Solved by D. C. in 27 mins
I need to return a order number in one cell. By matching a part number to a part number list on another sheet. And also, looking at a date of issue raised, against the purchase order received date on the additional sheet.
Solved by C. F. in 13 mins