Hello,

I'm working to insert new data to sheet 2. All the data is available in Sheet 1. I can use Vlookup function for Sheet2 to get value from column B of sheet 1. However, do you know any formula that I can use to find out any id of sheet 2 is missing from sheet 1 and add them to the id column of sheet 2 and add them to the next row of the last row instead.

Attached is the file Sample.xlsx . Please help me on this and thank you in advance.