Hello everyone! and help plsss

Hi,

I found this site very helpful but there are so many posts that I got confused about.

I need help with a formula i'm trying to figure out.

I have two columns. What I want to find is for the formula to look up for a value then look at its matching cell then output.

ex:
chose
groups --------------- OUTPUT-------
a B Group 1 group 2 group 3 group 4
1 1 1 1 0 1
4 1 0 0 0 2
4 2 0 0 0 0
2 1 0 0 0 0
6 1 0 0 0 0


I hope my explanation is not confusing,

A B C D
1 1 1 =COUNTIF(b$2:V2,V18)
2 1 2
3 2 1
4 3 1
5 4 1 FALSE
6 5 1
7 4 2
8 5 2
9 5 3
10 5 4
11 0
12 0
13 0
14 0
15 0
16 0
17 0
18 0