two arrays correction
 

Hi, Sorry the frist one fell apart when it sent. I am trying again.

In col A througn F there are numbers about 150 rows down.
In G1 through L1 there are numbers and these will change from time to time.
G2 through L2 and down I want a formula that will find the numbers that
are in A through F and put YES in the corresponding cell under G to L.
So any cell in A:F that has one of the numbers in G:L the formula will
put yes in the corresponding cell under G:L if the numbers is in G1:L1.

A B C D E F G H I J
2 8 11 50 43
32 21 5 23 50 Yes
9 43 21 18 22 Yes
2 34 1 54 8 Yes Yes

two arrays correction
 

Do you want the rows in A through F to match the first row in H through L?

If so, and I understand you correctly, try putting this formula in G2 and
copying it down and across: =IF(H$1=A2,"YES","")


"Jerry Kinder" wrote:

Hi, Sorry the frist one fell apart when it sent. I am trying again.

In col A througn F there are numbers about 150 rows down.
In G1 through L1 there are numbers and these will change from time to time.
G2 through L2 and down I want a formula that will find the numbers that
are in A through F and put YES in the corresponding cell under G to L.
So any cell in A:F that has one of the numbers in G:L the formula will
put yes in the corresponding cell under G:L if the numbers is in G1:L1.

A B C D E F G H I J
2 8 11 50 43
32 21 5 23 50 Yes
9 43 21 18 22 Yes
2 34 1 54 8 Yes Yes

two arrays correction
 

f2=If($F$1=A2,"Yes","")
copy this formula accross to J
then highlight F1:J1
copy (ctrl c)
Highlight the F3:J150 or however far down this goes
and then paste (Ctrl v)