HELP! array routine if less than or equal to
I'm a first time user. Need a routine to check the value in table1 if <= and return the value from table2. tried using vlookup but doesn't provide highest value. Trying to use array but don't know how to set up the routine. example: input is 25.00 If input is <= to table1 then result in table2 should be 36.75 Thanks for any help
11.75 16.50
23.25 30.25
29.00 36.75
35.00 43.50
I'm a first time user. Need a routine to check the value in table1 if <= and return the value from table2. tried using vlookup but doesn't provide highest value. Trying to use array but don't know how to set up the routine. example: input is 25.00 If input is <= to table1 then result in table2 should be 36.75 Thanks for any help
11.75 16.50
23.25 30.25
29.00 36.75
35.00 43.50
Last edited: