Excel linking multiple information
 

ok i have 2 worksheets. 1 is a list off ALL my trucks in order with a box for
me to type in the problems with that certain truck. 2 is work orderder sheet
for EACH individual trucks problems. How do i link it so when i type in the
truck number on the work-order sheet it pulls the problems from the full list
sheet?? thank you and i hope i explained it enough