I don't understand the first question.

The second...are you just wanting to expand that list of truck options? If
so, try this. You can make this as big as you want, just remember to keep the
first list ALPHABETICAL or it won't work:

=LOOKUP(I15,{"H","K","none"},{"Flatbed","Curtainsi der","Bobtail"})

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Suleman" wrote:

Dear sir,

i want that when C1=Suleman then next 4 or how much i selected cell change
the colour .
and one more question

i am useing that formula

=IF(I15<"None","Reefer","Bobtail")
now i want that when cell 115=none next cel become bobtail and if Cell115 =
H then next cell become Flatbed and if C115 = K then next Cell Become
Curtainsider

is that Possible Please Help Me