View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav
 
Posts: n/a
Default how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})


if the startuing values are entered a vlookup should suffice, something
like

0 5
0.01 6
1.01 7
2.01 10
5.01 12
7.01 15

If your cell value to lookup is in c1 something like the following
should work

vlookup(c1,$a$1:$b$36,2)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535575