Help with an IF, COUNT formula

[esj001]

this forum has saved me several times now and thought i would put this out there for the masters of Excel-------i have attached my worksheet, Column O has an IF formula that I would like to tweak if possible-----If column L has an H (stands for hours) I want the formula in O to say <=100--------If coulumn L has an M (stands for months) I want the formula in O (to say <= 6-----------If column L has an L (stands for landings) I want the formula in O to say <=150------------I have gone through and changed the values by hand in my attached spreadsheet, but this is going to be too time consuming once i start other sheets for other airplanes-------This is so I can make a this is DUE list for aircraft I am working on--------------Thanks in advance

[NBVC]

Try:

=IF(L8="","",LOOKUP(L8,{"H","L","M"},{"<=100","<=500","<=6"}))

copied down.

If you add more letter codes, make sure they are listed in the first array in ascending alphabetical order, then in show the desired results in corresponding position in 2nd array.

[esj001]

thank you sir