LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
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



All times are GMT +1. The time now is 01:40 AM.

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"