Urgent formula help please :)

[BecciB]

I have this formula:
=VLOOKUP(F7,Schools!A:B,2,FALSE)

I would like the destination cell (G7) to appear blank if there is no value in F7. Could you help me to create this formula?

Thanks Becs

 

[Joe4]

Try:

[COLOR=#000000][FONT=Inconsolata]=IF(F7="","",[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]VLOOKUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]F7[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#7E3794][FONT=Inconsolata]Schools!A:B[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]2[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]FALSE[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]))[/FONT][/COLOR]