![]() |
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