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!