creating a formula.

  • Thread starter Thread starter laz
  • Start date Start date
L

laz

Hi folks, I am trying to create a formula that will:

if a1:a4= to either values 1,2,4 and 12 where value #1 is "Annua
Leave" value 2 is "Sick Leave", value 4 is " Comp. Time", value 12 i
"Leave Without Pay" respectively then the answer should be inputted i
columns b1:b4 respectively. Can anyone help me create this formula
 
I'm not sure I understand your question, but here's a shot:

B1:
=IF(ISNA(MATCH(A1,{1,2,4,12},FALSE)),"",LOOKUP(A1,{1,"Annual
Leave";2,"Sick Leave";4,"Comp.Time";12,"Leave Without Pay"}))

copy down to B4.
 
Back
Top