Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default lookup

I am looking for either a macro or a function that will return a certain value.
ie: % With in Limits
test 100 99 98 97 96 .......
1 0.9 0.8 0.6 0.3 0.1
2 1.8 1.7 1.5 1.3 1.0
3 2.9 2.8 2.4 2.2 2.1

Test #2 find number 1.5 Return value 98

I hope someone can help me.
Eric