merge two excel sheets by ID - formula
1. ID must be in field A in both sheets
2. copy filed data from one sheet to another:
=IF(ISERROR(VLOOKUP(A2,'s2'!A:J,6,FALSE) ),"",VLOOKUP(A2,'s2'!A:J,6,FALSE))
where: A2 - ID in both sheets; 's2'!A:J - sheet name and table start-end; 6 - filed that needs to be copied over
2. copy filed data from one sheet to another:
=IF(ISERROR(VLOOKUP(A2,'s2'!A:J,6,FALSE) ),"",VLOOKUP(A2,'s2'!A:J,6,FALSE))
where: A2 - ID in both sheets; 's2'!A:J - sheet name and table start-end; 6 - filed that needs to be copied over
