Need help with creating a commission worksheet

[patxlb]

I need to create list of part numbers and the commission/piece. Every month I will be creating a worksheet showing the part numbers, quantities shipped, etc. What I'd like to be able to do is have the detail worksheet pull in the commission/piece whenever the part numbers match. Is there a way to do this?

Thanks.

[davesexcel]

of course, what have you got so far??

[patxlb]

What I have so far:

1. Worksheet listing part numbers, commission per piece and salesrep code
2. Worksheet listing part numbers, ship date, quantities shipped, and other detail

I need to take worksheet #2 and where there is a match in worksheet #1, create worksheet #3.

[Carim]

Hi,

First step is to look into the vlookup() function ...
to determine if it can sove your problem ...

HTH
Carim