Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function formatting
Hi. I am trying to return a value by looking up and intermediate value using
=LOOKUP(A1,Sheet2!$D$2:$B$91,Sheet2!$F$2:$A$91). For example: Worksheet 1: A1=well# B1=value from WS2 column F I'm looking for Worksheet 2: Column D= data values Column F=well#s A1-A12 Ct Well# 22.23 A1 22.18 A2 22.18 A3 24.36 A4 24.18 A5 24.02 A6 23.2 A7 24.2 A8 24.34 A9 19.15 A10 19.19 A11 19.43 A12 My problem is that when I input A1-A9 into cell A1 I get the proper values. Inputting A10-A12 always give me the value for A1. Please help. Thanks, Ben |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function formatting
As per the Excel help file: -The values in lookup_vector must be placed in ascending order- -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=559051 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Lookup function problem (kg) | Excel Worksheet Functions |