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