I have a bit of a problem here. We have a system where we make a purchase order in excel import it into QuickBooks then we export that info into kind of an excel based db, and from there extract information from the excel file to make job profitability reports.
I am trying to automate this system as much as possible until mgmt decides they are no longer in love with Excel spreadsheets. When QB exports this info it's in a csv file. I have to extract a detail number and item description out of a single cell, I am trying to do a vlookup for formula results. I have tried to add zero ect, but I can't get it to work.
Here is specifically what I am trying to do:
Book 1 is the db
I have a list of PO's separated by job number, detail number, vendor and description. I know I have some fat on the file, but I am just trying to get everything to work and then try to streamline it more.
Book 2 is a page from the job profitability file, which I want to make into a profitability and job status file to try and eliminate other Excel workbooks. So what I need to do is find out if there is a purchase order for the job number and detail number and return what the purchase order number is. I have gotten the formulas to work when I type in the job and detail numbers manually, but it will not work trying to do the vlookup just off the setup sheet numbers.
I have everything labeled in the two attached workbooks to hopefully make it easier.
Thank you in advance, I hope I have all the relevant information.
Bookmarks