LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jerry Kinder
 
Posts: n/a
Default two arrays

Hi,
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
K L
Numbers 3 5 12 16 34 27
38 40 48 52 56 46
34 32 33 43 53 9 Yes
8 15 16 24 38 19
13 15 16 32 41 22
23 36 27 41 42 21 Yes
11 27 32 48 52 28
5 7 12 16 45 19 Yes Yes
24 31 33 46 50 7
16 17 18 30 37 27 Yes Yes
2 13 16 37 44 32


Hope this makes sense.
Thanks,
Jerry


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using CORREL with arrays containing null values rmellison Excel Discussion (Misc queries) 1 November 11th 05 03:02 PM
vba adding arrays Jeff Excel Discussion (Misc queries) 1 November 4th 05 02:50 PM
Problem with plotting a chart when using arrays as Values and Xvalues [email protected] Charts and Charting in Excel 3 August 19th 05 09:05 PM
Confused about arrays and ranges in functions Llurker Excel Worksheet Functions 0 July 7th 05 05:44 AM
Comparing Arrays TangentMemory Excel Discussion (Misc queries) 2 May 13th 05 05:06 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"