formula to find certain number in a table when x axis and y axis are matched

good day
could anyone help me with a formula to find certain number in a table when x axis and y axis are matched

I have table 1


Table 1.jpg
A B C D E F G H
1 Jan Feb Mar Apr May Jun
2 Ben 1 1
3 Ben 1
4 Ben 1
5 Rick 1
6 Rick 1
7 Rick


then in Table 2
Table 2.jpg

K L M N O P Q R
1 Jan Feb Mar Apr May Jun
2 Ben
3 Rick

I would like to have a formula that will fill in the number 1 from Table 1 where Ben has a 1 under each month
so table 2 must have a 1 next to Ben for Jan ,Feb,May and June
and Rick must have a 1 for Mar and Apr

In M2, use

Formula:

Please Login or Register  to view this content.

Copy to the right and down.

thanks a lot quekbc
that works , but is there no formula that matches the name and the month
the main spreadsheet I have is like 3000 line with about 15 names all mixed in the sheet

=SUMIF($B$2:$B$7 , $L2 , C$2:C$7)

Bold matches Name and assuming months are from Jan to Dec in both tables then there is no need to match the month:it is "assigned" by default by copying across and down as quekbc stated

Extend B and C range to 3000

thanks for that John Topley and quekbc
have a great weekend