Creating an If statement

All,

I am working on a work book and need some help. I have a data page and a data needed page. Every time I upload the custmer information that I need from their website, it gives me their part number and not ours. I want to create something that will allow me to sort search the "data needed tab", where I have the customer part number in column a, our part number in column B and in column C I have our work center, based on the part numbers entered into column A I want to be able to populate Column G (work center) and Column H (our part number).

Does anyone know what I need to do. Thanks in advance for any help. I have not had any luck uploading this.

Thanks

Tommy