I have a excel sheet of 4 columns and thousands of rows.
One of the column have a unique item number.
If I enter the unique number in another excel sheet, the sheet should automatically search the previuos sheet and automatically past the remaining three columns correspond to that unique item number.