Compare lists and add text string

TASK-1 Insert Patent Type Intent drag in an existing value (if a row ID exists) else: add new row with 2-column ID. i.e. compare Sheet-1 & Sheet-2 TASK-1 I would actually prefer a generic spreadsheet vs. canned VPA app. For this one 1 User pastes 100-Colums by 1000-Rows of data on Sheet-1 2 User pastes 2 Columns by 1000-rows of data on Sheet-2 3 ignore header row 4 Sort sheets 1 &2 by col A ignoring Header both sheets 5 User or program needs to create NEW Sheet-3 (1 new column for the insertion of new text string 20 char max from Sheet-2 col-B) 6 If Sheet-1 Col-1 cel A2 thru A1000 is on Sheet-2 Col-A THEN (add Text from Sheet-2 Col-2 to Sheet-3 Nu Column) 7 Else insert new row with not-present Seet-2 Col-A and Col-B data) have excel example if not clear