Vlookup

[RLJ]

I need this formula to show a 0, if it is nothing

=VLOOKUP(G6,$L$6:$M$50,2,FALSE)

 

[njimack]

Do you mean if the lookup value doesn't exist in the lookup range? If so:
=IF(COUNTIF($L$6:$L$50,G6),VLOOKUP(G6,$L$6:$M$50,2,FALSE),0)

 

[Comfy]

n/a

 

[RLJ]

Perfect.

 

[barry houdini]

Not sure what you mean. Do you mean show zero instead of #N/A? In excel 2007 try using IFERROR

=IFERROR(VLOOKUP(G6,$L$6:$M$50,2,FALSE),0)