Thread: Look-Up Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark B. Mark B. is offline
external usenet poster
 
Posts: 19
Default Look-Up Help

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.