Iwant to use list,while using if function. ie
if cell A1 = Lorry expenses i want the following in B1 and i will select any
one of the following by using function.
Fuel exp
Retreading exp
Police exp
vehicle maintenance exp
FC expenses
Tax
other exp
ic cell A! = Driver pay i want the following in B1 and i will select any one
of the same
Kumar
Raja
Mahesh
Karthik
vishnu
alex
christy
Bernie Deitrick - 30 Aug 2006 13:27 GMT
rvs,
See:
http://www.contextures.com/xlDataVal02.html
HTH,
Bernie
MS Excel MVP
> Iwant to use list,while using if function. ie
> if cell A1 = Lorry expenses i want the following in B1 and i will select any
[quoted text clipped - 16 lines]
> alex
> christy