=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. 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).

Mac excel 2013 freeze big file