Hi,

My question refers to the following table:

12 11 10 9 8 7
49 800 800 800 800 790 760
48 800 800 790 770 750 730
47 800 780 770 750 720 700
46 780 760 750 730 700 680
45 760 750 730 710 690 670

I want to write a function that can match a score from the far left column
with a score from the top row and place the resulting number in a specific
cell. For example, the specific cell would = 690 if the scores are 45 and 8.
Can someone help me figure this out? Thanks.

Try this:

With your table in the range A1:G6

A10 = 45
B10 = 8

=VLOOKUP(A10,A1:G6,MATCH(B10,A1:G1,0),0)

--
Biff
Microsoft Excel MVP


"Mark B." wrote in message
...
Hi,

My question refers to the following table:

12 11 10 9 8 7
49 800 800 800 800 790 760
48 800 800 790 770 750 730
47 800 780 770 750 720 700
46 780 760 750 730 700 680
45 760 750 730 710 690 670

I want to write a function that can match a score from the far left column
with a score from the top row and place the resulting number in a specific
cell. For example, the specific cell would = 690 if the scores are 45 and
8.
Can someone help me figure this out? Thanks.

Thanks a ton! I really appreciate it.

This is the first time that I've tried this and I'm kicking myself for not
discovering it years ago.

"T. Valko" wrote:

Try this:

With your table in the range A1:G6

A10 = 45
B10 = 8

=VLOOKUP(A10,A1:G6,MATCH(B10,A1:G1,0),0)

--
Biff
Microsoft Excel MVP


"Mark B." wrote in message
...
Hi,

My question refers to the following table:

12 11 10 9 8 7
49 800 800 800 800 790 760
48 800 800 790 770 750 730
47 800 780 770 750 720 700
46 780 760 750 730 700 680
45 760 750 730 710 690 670

I want to write a function that can match a score from the far left column
with a score from the top row and place the resulting number in a specific
cell. For example, the specific cell would = 690 if the scores are 45 and
8.
Can someone help me figure this out? Thanks.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mark B." wrote in message
...
Thanks a ton! I really appreciate it.

This is the first time that I've tried this and I'm kicking myself for not
discovering it years ago.

"T. Valko" wrote:

Try this:

With your table in the range A1:G6

A10 = 45
B10 = 8

=VLOOKUP(A10,A1:G6,MATCH(B10,A1:G1,0),0)

--
Biff
Microsoft Excel MVP


"Mark B." wrote in message
...
Hi,

My question refers to the following table:

12 11 10 9 8 7
49 800 800 800 800 790 760
48 800 800 790 770 750 730
47 800 780 770 750 720 700
46 780 760 750 730 700 680
45 760 750 730 710 690 670

I want to write a function that can match a score from the far left
column
with a score from the top row and place the resulting number in a
specific
cell. For example, the specific cell would = 690 if the scores are 45
and
8.
Can someone help me figure this out? Thanks.