Hi Girls and Guys,
New member here coming to you cap-in-hand for advice.
I have two workbooks that I need to make work together with the result being a semi-automated report. Workbook A is the one that I have built to compare values and is a .xlsx file (2010). Workbook 2 is a .xls ('97 clunker) that is the result of a PDF-to-Excel conversion from our internal reporting.
What I need to do is Vlookup a number from my built .xlsx workbook and return a value taken from the .xls workbook.
What I have is:
Workbook A (2010) has a list of differing raw numbers listed in column 'A' (e.g. '12345' etc). I need to reference workbook B (antiquated 97) for those numbers and return the quantity listed against those numbers in that sheet on workbook A. Easy! Not so much. Workbook B has the number I need in its column A but due to the stupid conversion, it combines the number with a description (i.e. '12345 (description that CRFaig doesn't want)'
So...I have tried to correct this by making an additional .xlsx workbook that does the '=A1'[jdjdjjjd.xls. etc]' and then adding a column B with a MID formula which returns the raw number and ignores the text within the brackets. My report file vlookup's from this workbook. It works but, seriously, I can grow half a beard waiting it to open on a decent-RAM'd PC.
What I would like to know is, if it can be done, can a forula combining vlookup and MID functions make my built sheet return a value looked up on a sheet that has a number/then space/then bracket/then description/then closed bracket without needing a third conversion from a 'number with the stuff in the brackets removed' sheet?
Bookmarks