want to use list, while using if function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using list function while using if conditions 1
how to use if formula in list (data validation list) 1
Match - not sure how to use this function 3
Using date function in an if statement 2
How to use the IF Function for 3 conditions 5
price list changes using conditional functions? 3
Trying to get contents of cell linked through IF function. 2
use if function to change cell color 2

Back
Top