That information was part of an extremely large mysql file which I imported into mysql and then pulled out those two columns.įor whatever reason Apple did not include the "genre" category in the mysql file so the only way was to pull every product, but only what I needed - the ID field and description - so I could do the vlookup and add the description to the appropriate, corresponding, ID/item on sheet1. The first sheet I pulled from a flat file - very simple, easy to work, etc…but, unfortunately, that flat file does not include the "description" column that is found on sheet 2. If at all it is possible to get the text file with the IDs in sorted order, it might be better to split it into at least 2 text files, so that we can straightaway decide which of the files will contain the ID we are looking for.
Xlstat causes excel to stop responding code#
If at all your first file is just 9 MB in size, why not leave the second file as a text file, and use code to do a search within the text file ? Is there any logic to the ID numbering ?įrom what I can see, Sheet2 has IDs which all start with 651 the data on Sheet1 does not have a single ID starting with 651 what is the purpose of this formula in the first place ?ģ. Why are there 2 sheets of information ?Īs far as I can see both sheets have unique entries per ID Sheet2 does not have any other information except the description of each ID so why was this not in Sheet1 to start with ?Ģ. You might have got your answer by now, but if you don't mind, I'd like to ask a few questions which I don't see in this thread.ġ. =IFERROR(VLOOKUP(A2+0,Sheet2!A:B,2,0),"")Īgain, not sure if Excel is the way to do this so I'm open to any and all suggestions. I want those descriptions, where the ID numbers match, to populate column "U" on sheet1.
Sheet 2 only has 2 columns - column "A" is "id" and column "B" is "description" So both sheets have id numbers in column 1. So, basically, I'm hoping to populate a clumn in sheet 1 (the next open column is "U") where the id number matches the id number on sheet 2, column 1. How can I create a description column on sheet1 (it would be column "U") and populate it with the description from sheet2 only where the "id" values from column "A" match? Sheet 2 only has 2 columns - "A" is the "id" column and "b" is the "description" column. Id numbers that are also, some, found in column "A" of Sheet2 - which is also titled "id". I'm running Excel 2013 and I have one workbook with two sheets - sheet1 and sheet2.
Xlstat causes excel to stop responding pro#
I have access to a wide variety or tools - Access, SQL server, Foxpro 9, Filemaker Server Pro 11, Office 2010 & 2013 but, as a network engineer, my knowledge programming and databases is somewhat limited and I'm wondering if anyone can help out - maybe Excel isn't the right tool for this particular job? I've even installed Powerpivot in both versions - although I know little about it - and when trying to import the 1.3gb txt file I get memory errors. I'm running a virtual server on MS Azure with 8 core and 54gb ram and nothing running on it (task manager shows cpu usage at 2% and ram at 5%). Even if I apply the formula below, I still can't sort it without Excel "not responding". "Sheet2" is 1.35Gig with 1.33 Million rows and two columns.Įven breaking sheet2 up into 10, 130 mb, files, I can't manipulate the data. The problem I'm now facing is my original "sheet1" is almost 25,000 rows and 19 columns and is 9 Mb in size. Pasted below is my original question - which was answered with a formula that works perfectly! I've posted twice on here and got excellent results - when working with my "test workbook" - which is a small portion of the original 2 sheets (I'll upload the test file).
0 kommentar(er)
