search and showing results

need some help please

sheet 1 has my data in columns a-e

in sheet 2, i want to input data into a cell that will match data in column b (a unique number including letters) in sheet 1. how do i get sheet 2 to show the rest of the data in the row at matches what i have inputted?

Assuming you type the code into column A on sheet2, in column B use this formula:
=VLOOKUP($A1,SHEET1!$B$1:$E$10,2,FALSE)
VLOOKUP will search column A of sheet1 and find the first instance of the code you entered in sheet2!A1 and return the data from the matching row in column C of sheet1. Adjust the ranges to suit your data, then fill the formula right to fill columns C:E. You will also need to adjust the column number in the formula (2) so that in columns C, D & E it returns columns 3, 4 & 5 from sheet1. Next, fill the formula down as far as necessary.

Hope this helps.