If with vlookup

Well, the OP said originally that:

this formula works for me

and just wanted to cope with spaces - clearly, it didn't work very well.

Pete

Originally Posted by Pete_UK

Well, the OP said originally that:



and just wanted to cope with spaces - clearly, it didn't work very well.

Pete

Thank u pete actually its working first time i copy down it cell reference changing so i figured out like this

=IF(K1="","",IF(K1="w","no",VLOOKUP($K$1,$E$3:$E$12,1,0)))

now its working fine

thanks again.

MJR