| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I lookup two reference points ??
Anyone please tell me, can I lookup values by using two reference points? Imagine, say, I have two rows of data: Red 1000 2000 3000 4000 5000 ......49.5 67.91 76.3 22.41 31.8 and I want to lokkup "Red" 3000 (to get the result "76.3) -is there a formula to help me do this? The s/s is over 320000 rows deep. Big thanks. Colwyn. -- colwyn ------------------------------------------------------------------------ colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=40942 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
| Lookup or reference 3 data points | Excel Worksheet Functions | |||
| Formula using 2 points of reference to return a value from a table | Excel Worksheet Functions | |||
| Linear interpolation between two points found using a lookup funct | Excel Worksheet Functions | |||
| Excel Reference points to original file | Excel Discussion (Misc queries) | |||
![colwyn[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
