Tagged Questions

2
votes
1answer
81 views

Merging Excel files on a keyfield

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, ...
1
vote
2answers
117 views

Formula to merge column from sheetA to sheetB to matching ID

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 ...
0
votes
2answers
846 views

Merge two Excel sheets

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