Find And Match And Tally With 2 Workbooks

I have 2 workbooks. and i would like to do the following:

Workbook1

- 4 columns (product ID, quantity, Group, Comments)

Product ID, Quantity, Group, Comments
11111, 500, ?,?
11122, 1000, ?,?
11133, 250, ?,?
11144, 250, ?,?
11343, 700, ?,?
12134, 750, ?,?

Workbook2

- 2 columns (group A, Group B)

for group A:
min qty: 250
min increment: 250........................

1) I need to match the product ID in workbook1 with workbook2 - see which group it belongs and put into workbook1 under column group

2) I need to count the no.of quantity and see if it meet the citeria and place Yes/No in workbook1 column under Comments.

- for example:
product ID 11111 in workbook1 can be found in workbook2 group A (put group A into workbook1 under column group)

do a check: prodct ID 11111 has 500 in quantity, since its under group A it meets the min qty of 250. and followed by it meets the min increment too - 500/250 (thus put Yes into workbook1 column under Comments)