Selection of rows by matching with multiple values of a field in a different table

Dear All,

This is my problem:

1)I have a table with these fields (columns):
- id
- ideas_id
- boxes_id
- status

2)and another table with these fields (columns):
- id
- name
- description

the field "boxes_id" in the first table has the same meaning of the field "id" in the second box; but in the second table I have less values;

what I want to get is:
a new table with the same fields of table 1;
the condition that a row of table 1 has to verify to be part of the resultant table is: the value of "boxes_id" has to match any value of "id" in table 2; I don't want to specify a value of "id", I want to consider all the different "id" values in table 2 in the check condition.

I hope to have made me clear. I am not sure!

Thank you very much for the help!!
Mirco.

As soon as I will be able to try it, I will let you know the result.

Thank you very much!

I have tryed, but Excel tells me that the typed formula has an error and it select the bolded part of the formula:

=IF(COUNTIF(Sheet2!A:A,C2),Max(E$1:E1)+1,"")

Thank you very much!

Mirco.

Sorry!

Now I should have updated the information: I am an Italian student studing in Sweden.

About the formula, I have changed the commas with semicolons: Excel doesn't say me anymore that there is an error,
but when I insert the formula, the classic window to open a file shows on the screen and the header of this window is: (it is my translation from Italian, I don't know if it is the same in the english version)
"Update values: Sheet2"

Is it normal?

Which file do I have to select?

Sorry for the questions, I am not really in Excel.

Thank you very much!