If with vlookup

Originally Posted by pete_uk

did you try this?

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

hope this helps.

Pete

thanks but not working vlookup function.

Only works if..

Mjr