Hello everyone,
I have an excel file (1) that is regularly updated with new unique id's that contain values per specific columns (unique column names).
I also have a separate spreadsheet file (2) that contains a subset of the data in file (1), along with other columns and data.
I'd like to enter a new unique id into file (2) and use a formula to populate the values in file (1), to file (2) by matching the unique id in file (1) with the unique id in file (2), and also the column names.
Thanks in advance for your help.
--------------------------------------------
I have an excel file (1) that is regularly updated with new unique id's that contain values per specific columns (unique column names).
I also have a separate spreadsheet file (2) that contains a subset of the data in file (1), along with other columns and data.
I'd like to enter a new unique id into file (2) and use a formula to populate the values in file (1), to file (2) by matching the unique id in file (1) with the unique id in file (2), and also the column names.
Thanks in advance for your help.
--------------------------------------------
parse data.xlsm | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |||
1 | test | ||||||||||||||||||||||||||
2 | File 1 data | unique id | leauv(ka) | vxznq(im) | wulw(de) | mszin(nc) | ycgow(vj) | ixvjk(ay) | jcth(pl) | pdzwz(xh) | blntb(vr) | ysrik(lw) | vwzjq(jx) | tvdfh(cp) | vxrb(vz) | qulji(ix) | gouyw(dy) | qcujx(ez) | mwqov(yf) | stviy(xj) | qzotg(tt) | itbl(bh) | jbson(mx) | ygwbu(ug) | |||
3 | 489 | 12 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | text1 | text2 | 258 | 259 | 260 | 261 | 262 | 263 | 264 | 265 | 266 | 267 | 268 | ||||
4 | 547 | 17 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | text2 | text3 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | ||||
5 | 687 | 19 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | text3 | text4 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | ||||
6 | |||||||||||||||||||||||||||
7 | |||||||||||||||||||||||||||
8 | |||||||||||||||||||||||||||
9 | File 2 parsed data | unique id | leauv(ka) | ycgow(vj) | vwzjq(jx) | qulji(ix) | itbl(bh) | ygwbu(ug) | |||||||||||||||||||
10 | 489 | ||||||||||||||||||||||||||
11 | 547 | ||||||||||||||||||||||||||
12 | 687 | ||||||||||||||||||||||||||
13 | many other columns and rows in file 2 that are not in file 1 | ||||||||||||||||||||||||||
Sheet1 |