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

Have a look at the VLOOKUP function in excel Help...

e.g.

=Vlookup(A1,$B$1,$D$100,3,FALSE)

this looks at entry in A1 finds it in first column of a table in B1:D100 and returns info from 3rd column in this table (i.e. column D)...