View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jerry Kinder
 
Posts: n/a
Default 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