Search and paste corresponding details

[haddo]

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.

[jayatu chatterjee]

By using VLOOKUP or INDEX, MATCH function you can get the value.

= Index(column, match(value, column,0))...
If you need further help please provide one sample file

[haddo]

thank you
by using vlookup I got the solution