VLookup and IF formula

[NJS1982]

Hi all, just hoping somebody can help advise me!
I have a spreadsheet, with different tabs. On a 'final' sheet, I want to display the contents (financial figures) from another, so using the formula:

=VLOOKUP(A115,'OA Report'!$A$1:$O$5000,11,0).

Some results of this, rightfully, are pulling through a value of '£ - ', which is what I want.

I want to however display the % in another column (L), so I then have a formula:

=L115/K115

However, because the value in K115 is '£ - ', the % return in column L is showing as #DIV/0!, rather than treating '£-' as '£0'. If this cell is 0, then the return in L is always 100%.

I tried =IF(K115="-","100",L115/K115), it did not work (perhaps due to the Vlookup?) but think I need to do something in the VLookup column in the first instance? I know I can change the source on the original sheet to 0, but for various reasons I can't do that!

[Glenn Kennedy]

try:

=iferror(L115/K115,"")

or (if as your profile states) you are using Excel 2003:

=if(iserror(L115/k115),"",L115/k115)

[NJS1982]

That's great, thanks. Slightly changed, to not show a blank if there is an error, but "100%'.
Also, thanks for pointing out my profile...no, now on 2013! Thanks, will update.