Correcting Percentage in formula

[OfficeUser]

I currently have a formula:
=IF(Efficiencies!$B10="","",VLOOKUP(Efficiencies!$B10, CorrelationsRounded!$A$1:$B$10002, 2, FALSE))

I changed the cell containing the formula to a percentage format. The number in that cell goes from 113.70 to 11370.00%. I changed my formula to:
=IF(Efficiencies!$B10="","",VLOOKUP(Efficiencies!$B10, CorrelationsRounded!$A$1:$B$10002, 2, FALSE))/100

This corrects it to show 113.70%. The problem is that if Efficiencies!$B10="" then the cell with the formula above shows a #VALUE! error. What am i doing incorrectly? Thanks for the help.

 

[OfficeUser]

Oops, got it now:
=IF(Efficiencies!$B10="","",VLOOKUP(Efficiencies!$B10, CorrelationsRounded!$A$1:$B$10002, 2, FALSE)/100)