June 2011 Archives

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