vlookup looking for the next higher value?
 

I would like to look-up a value in a table. and in case of not an exact match
select the next higher value.
Vlookup rounds of downwards.

vlookup looking for the next higher value?
 

I'm sure someone has a better method, but if you insert a column within
your lookup table (or on the right of it) you can use that as an offset
to pick up the next higher value.

See attached, the working line is


=IF(VLOOKUP(A21,$A$1:$C$9,1,2)=A21,VLOOKUP(A21,$A$ 1:$C$9,1,2),OFFSET($C$1,VLOOKUP(A21,$A$1:$C$9,2,2) ,0))


where column B is the increment column.

Hope this helps.


deugniet418 Wrote:
I would like to look-up a value in a table. and in case of not an exact
match
select the next higher value.
Vlookup rounds of downwards.


+-------------------------------------------------------------------+
|Filename: RowPlusOne.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4095 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=490679

vlookup looking for the next higher value?
 

=IF(VLOOKUP(C1,A1:B6,1)=C1,VLOOKUP(C1,A1:B6,2),IND EX(B1:B6,MATCH(C1,A1:A6)+1))
Table in A1:B6, search value in C1
--
Kind regards,

Niek Otten

"deugniet418" wrote in message
...
I would like to look-up a value in a table. and in case of not an exact
match
select the next higher value.
Vlookup rounds of downwards.

vlookup looking for the next higher value?
 

One more...

=INDEX(Sheet2!B:B,MATCH(A1,Sheet2!A:A,1)+ISERROR(M ATCH(A1,Sheet2!A:A,0)))

The table is in sheet2, columns A:B (I brought back column B, but matched on
column A)



deugniet418 wrote:

I would like to look-up a value in a table. and in case of not an exact match
select the next higher value.
Vlookup rounds of downwards.

--

Dave Peterson