Hi to all,

=if(k1="w","no",vlookup(k1,e3:e13,1,0))

this formula works for me but if k1 is blank then it must me blank also i try to figured out for my self but its not coming

can any one tell me ?

Thanks in advance.....

Mjr