R r_2 Member Jul 4, 2014 #1 Hi, Unable to get the desired result. Requirement: in column D, source is column C if c5 >200 , D5=7 c6 <=200 , D6=5 c7 <=200, d7= 5 Attachments if criteria sample.xlsx 10.7 KB · Views: 4
Hi, Unable to get the desired result. Requirement: in column D, source is column C if c5 >200 , D5=7 c6 <=200 , D6=5 c7 <=200, d7= 5
B Bhawani Member Jul 4, 2014 #2 As column C contain text you should use below function Code: =IF(C5=">200",7,IF(C5="<=200",5,5))
Somendra Misra Excel Ninja Jul 4, 2014 #3 Hi @r_2 Two more alternative using lookup functions: 1. in C5 =INDEX($D$2:$D$3,MATCH($C5,$C$2:$C$3,0)) copy down OR 2. In C5 =VLOOKUP(C5,$C$2:$D$3,2,0) copy down. Regards,
Hi @r_2 Two more alternative using lookup functions: 1. in C5 =INDEX($D$2:$D$3,MATCH($C5,$C$2:$C$3,0)) copy down OR 2. In C5 =VLOOKUP(C5,$C$2:$D$3,2,0) copy down. Regards,
