So how do you expect for the formula to find the description?

You need to have a table that lists the various possible part numbers and their respective descriptions so that when you type a part number into A2, then the formula will return the appropriate description.