4 arrow sets

[hsandeep]

C2=Either of 1,2,3,4 or null

Output required: B2=CF1 for C2=1 else CF2 for C2=2 else CF3 for C2=3 else CF4 for C2=4

CF1=1 THEN 2 arrows UP (straight)
CF2=2 THEN 2 arrows Horizontal & UP
CF1=3 THEN 2 arrows DOWN (straight)
CF1=4 THEN 2 arrows Horizontal & DOWN

How to accomplish?

Using Excel2007.

 

[Scott Huish]

Here's your formula for B2:
=IF(AND(C2>0,C2<5),INDEX(CF1:CF4,C2),"")

I don't understand the next part, why did the second range change to CF2?

CF2=2 THEN 2 arrows Horizontal & UP

and where did you want these arrows?