want to use list, while using if function?

[rvs]

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]

rvs,

See:

http://www.contextures.com/xlDataVal02.html

HTH,
Bernie
MS Excel MVP