Conditional Remark

**santosh226001** · 01-03-2014, 06:53 AM

Hello All
We have a sheet where we want to conditional remarks in Remarks column
if Colum B value <=300 then Remarks <Blank>
if Colum B value >=300 then Remarks Above 3 Cr
Etc total 8 condition which is in sample file..

We want remarks in Column C... we also show example remarks in Colum D which we want in Colum C

Thanks in Advance

Santosh

**benishiryo** · 01-03-2014, 07:00 AM

hi Santosh. could you just put the minimum values in column I & a real blank in K3. then use:
=LOOKUP(B2,$L$3:$L$10,$K$3:$K$10)

of course, you could put it else where to lookup or just put in fixed values like:
=LOOKUP(B2,{0;300;350;390;400;450;490;500},{0;"Above 3 Cr";"Above 3.5 Cr";"Near 4.0 Cr";"Above 4.0 Cr";"Above 4.5 Cr";"Near 5.0 Cr";"Above 5.0 Cr"})