In M1, enter formula:
=VLOOKUP(L1,{0,4;5,5;20,6;120,7},2,1)

That will automatically calculate M1

HTH
--
AP

"grahammal" a écrit
dans le message de
...

If Sheets("Sheet1").Range("L1") 0 Or Sheets("Sheet1").Range("L1") < 5
Then Sheets("Sheet1").Range("M1") = 4 :End

If the above is 4 or < 20 Then M1 = 5
If the above is 19 or < 120 Then M1 = 6
If the above is 119 Them M1 = 7

The above are the conditions that I want to set so that the value that
appears in column M is dependant on the value that is entered in column
L.
How do I write the formula?
How do I attach it to all the rows in column M?

I need this because the value that appears in column M will be used as
the column number that I will use in a VLOOKUP table.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile:
http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=520529