software

I would like to find the intersection of two variable data points in an
array. So in the chart below I would like to have a seperate cell (call it
H1) dictate what year in column A to look for and then another cell (call it
H2) dictate what word to look for in Row 1 and then find the interestion
between them (if the year is 1935 and the word was house then answer is 5)
AB CD
1Yearcarhousekids
21933855
31934474
41935656
51936848
619371023
719381234

Thank you for any help that you can give me.

Try this:

With your data in A17

H1: (a year)
H2: (a word from the 1st row)
H3: =INDEX(A17,MATCH(H1,A1:A7,0),MATCH(H2,A11,0))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXPquot;beauknowssoccerquot; wrote:

gt; I would like to find the intersection of two variable data points in an
gt; array. So in the chart below I would like to have a seperate cell (call it
gt; H1) dictate what year in column A to look for and then another cell (call it
gt; H2) dictate what word to look for in Row 1 and then find the interestion
gt; between them (if the year is 1935 and the word was house then answer is 5)
gt; AB CD
gt; 1Yearcarhousekids
gt; 21933855
gt; 31934474
gt; 41935656
gt; 51936848
gt; 619371023
gt; 719381234
gt;
gt; Thank you for any help that you can give me.

=INDEX(A17,MATCH(H1,A1:A7,0),MATCH(H2,A11,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;beauknowssoccerquot; gt; wrote in
message ...
gt; I would like to find the intersection of two variable data points in an
gt; array. So in the chart below I would like to have a seperate cell (call
it
gt; H1) dictate what year in column A to look for and then another cell (call
it
gt; H2) dictate what word to look for in Row 1 and then find the interestion
gt; between them (if the year is 1935 and the word was house then answer is 5)
gt; A B C D
gt; 1 Year car house kids
gt; 2 1933 8 5 5
gt; 3 1934 4 7 4
gt; 4 1935 6 5 6
gt; 5 1936 8 4 8
gt; 6 1937 10 2 3
gt; 7 1938 12 3 4
gt;
gt; Thank you for any help that you can give me.
Thanks Bob, you also found the solution to my problem.

quot;Bob Phillipsquot; wrote:

gt; =INDEX(A17,MATCH(H1,A1:A7,0),MATCH(H2,A11,0))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;beauknowssoccerquot; gt; wrote in
gt; message ...
gt; gt; I would like to find the intersection of two variable data points in an
gt; gt; array. So in the chart below I would like to have a seperate cell (call
gt; it
gt; gt; H1) dictate what year in column A to look for and then another cell (call
gt; it
gt; gt; H2) dictate what word to look for in Row 1 and then find the interestion
gt; gt; between them (if the year is 1935 and the word was house then answer is 5)
gt; gt; A B C D
gt; gt; 1 Year car house kids
gt; gt; 2 1933 8 5 5
gt; gt; 3 1934 4 7 4
gt; gt; 4 1935 6 5 6
gt; gt; 5 1936 8 4 8
gt; gt; 6 1937 10 2 3
gt; gt; 7 1938 12 3 4
gt; gt;
gt; gt; Thank you for any help that you can give me.
gt;
gt;
gt;

Thank you Ron. That worked out great! You have been a huge help.

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; With your data in A17
gt;
gt; H1: (a year)
gt; H2: (a word from the 1st row)
gt; H3: =INDEX(A17,MATCH(H1,A1:A7,0),MATCH(H2,A11,0))
gt;
gt; Is that something you can work with?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;beauknowssoccerquot; wrote:
gt;
gt; gt; I would like to find the intersection of two variable data points in an
gt; gt; array. So in the chart below I would like to have a seperate cell (call it
gt; gt; H1) dictate what year in column A to look for and then another cell (call it
gt; gt; H2) dictate what word to look for in Row 1 and then find the interestion
gt; gt; between them (if the year is 1935 and the word was house then answer is 5)
gt; gt; AB CD
gt; gt; 1Yearcarhousekids
gt; gt; 21933855
gt; gt; 31934474
gt; gt; 41935656
gt; gt; 51936848
gt; gt; 619371023
gt; gt; 719381234
gt; gt;
gt; gt; Thank you for any help that you can give me.