Try to create a order form

Good evening

I was sat wondering if this idea is possible or not has been I while since I e excel
Wether could make an Order form up to speed things up at work

say column A was the product numbers and B was the description on sheet 1

Would it be possible if you typed the description in a cell on sheet 2 could a formula search through and paste the product numbers in the cell next to it

Many thanks