If with vlookup

**mjr10891** · 02-21-2013, 07:20 AM

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

**Pete_UK** · 02-21-2013, 07:31 AM

Did you try this?

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

Hope this helps.

Pete

**mjr10891** · 02-21-2013, 08:35 AM

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

**martindwilson** · 02-21-2013, 08:46 AM

=vlookup(k1,e3:e13,1,0) wont that return either #n/a or whatever is in k1?

**rb_inspire** · 02-21-2013, 09:48 AM

How about this?

=IF(K1="w","no",IF(ISERROR(VLOOKUP(K1,E3:E13,1,0))," "))

Regards
RB

**martindwilson** · 02-21-2013, 10:19 AM

=IF(K1="w","no",IF(countif(E3:E13,k1),k1,"")

**Pete_UK** · 02-21-2013, 10:23 AM

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

**mjr10891** · 02-22-2013, 05:39 AM

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