Using the answer to this question as my starting point, I have a slightly different scenario that I'm stuck on. Consider: File 1: Incident# (key), foo1, foo2, foo3 File 2: Incident# (key), status, ...
Match unique id Sheet1!A2 to a cell in Sheet2!A2:A100 that has the matching ID. Paste cell content from column Sheet2!C2:C100 from the same row with the matching id in Sheet2 to the cell with formula ...
I have two 'tabs' in my Excel file and I would like to merge the two tabs into one sheet (in the same file). The two files look somthing like: artnr language description price artnr ...