Hi there,
have searched and searched with no clear explanation of how a search code would work so i have been studying up but i cant see where to start.

I have a spreadsheet, in this spread sheet are staff and personnel numbers. however there are 3 columns of staff names and 3 columns of personnel numbers, above the names of the staff in seperate columns are contract, permanent and temporary which these staff all fall under.

to display it i guess it would look like this

TEMP/ /PERM/ /CONTRACT/
name /number /name /number /name number/


what i want to do is enter the personnel number which will inturn display the

status ie temp,contract,perm and the staff name.

i know there is an easy way because i was going to simply start entering line and line of the following code to match each each cell which defeats the purpose.

if Worksheets("staff").Range("A1").Value = TextBox1 then 'carry on code to display several cell contents
if Worksheets("staff").Range("A2").Value = TextBox1 then 'carry on code to display several different cell contents etc etc:)