ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I use <= in a lookup array? (https://www.excelbanter.com/excel-discussion-misc-queries/32961-how-do-i-use-%3C%3D-lookup-array.html)

Gdog34

How do I use <= in a lookup array?
 
Hi
I'm trying to write a function where when you input a value in 1 cell, the
formula will check the number and return a value in another cell.
So far I have this:
=LOOKUP(A5,{60,100,150,200,250,300,350,400,450,500 ,600,700,750,800,900,1000,1250,1500,1750,2000},{0. 3,0.46,0.64,0.79,0.94,1.07,1.21,1.4,1.59,1.78,2.15 ,2.52,2.71,2.9,3.27,3.64,4.52,5.4,6.28,7.16}
This is all very well but I want it to test for less than or equal to for
every value in the first array, putting <= next to the numbers generates an
error. I've tried using brackets but still it errors any help would be
gratefully appreciated


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com