Hi Thanks for your instant response!
This would be like a search/find function but it automatically search a list of items one by one in another file instead of enter each item manually.
For instance:
1st file:
ID1 description
1 absent
2 present
3 present
4 absent
5 absent
6 present
7 present
8 present
9 absent
10 present
11 present
12 present
13 present
14 absent
15 absent
16 present
17 present
18 present
19 present
20 present
21 present
22 absent
23 absent
24 absent
25 absent
26 absent
27 absent
28 absent
29 absent
2nd file:
ID2
1
5
7
3
23
5
24
12
25
2
6
11
18
16
The results:
1 absent
5 absent
7 present
3 present
23 absent
5 absent
24 absent
12 present
25 absent
2 present
6 present
11 present
18 present
16 present