All Questions
2
questions
2
votes
1
answer
73
views
Not getting desired output with VLOOKUP - Need assistance
I have Table 1, which looks like this -
A1 B1 C1
1 X Date11
2 Y Date12
3 Z Date13
I have another table, Table 2, that looks like this -
A2 B2 C2
1 M Date21
2 N Date22
3 X ...
1
vote
2
answers
201
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 ...