Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup a range of numbers
Hi,
I have a table as follows: (Speed) (Dist) 64k 128k 256k 5 1000 1200 1500 10 1600 1700 1800 15 2000 2100 2200 I'd like to have a formula whereby if I key in a Distance of 4 and a speed of 256k, the active cell will show "1500". I tried to use sumproduct but seems like sumproduct can only be used if the Dist is exactly "5", "10", etc. The only alternative I can think of is to list out ALL the integers for Distance. But, is there an easier way? Thanks, val |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions | |||
How to add one number to a range of numbers | Excel Worksheet Functions | |||
How do I add a range of numbers to sum a specific total? | Excel Worksheet Functions | |||
How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions |