How to return a Value rather than "False" in a formula

[pedro-egoli]

Have 2 worksheets .
in sheet 1, I have intermittent dates in column A and associated balances in column G .
In sheet 2 I have dates that change daily (in most cases) starting in BH2

When a report is issued I indicate this by placing a tick "char(252)" in Row 18.
The date (column A) and movement since last report are shown in column G on sheet1

The formula I need is to cover
1, the movement since last report when a new report issues
or
2 If no new report the difference betweem row cell in rows 16 and 27 of that days column
This formula works when dates on sheet 1 coincide with date on sheet 2 and when
problem I have is that when dates dont match on each sheet , or when there is no report I get a FALSE from my poor formula
Formula in Sheet 2 cell BH28 is

=IF(BH2="","",IF(BH18=CHAR(252),INDEX('Sheet 1'!$G9:$G200,MATCH(BH2,'Sheet 1'!$A9:$A200,$BH16-$BH27))))

Would appreciate a formula /code covering 1 and 2 above

 

[jasonb75]

The FALSE argument of your second IF is empty

=IF(BH2="","",IF(BH18=CHAR(252),INDEX('Sheet 1'!$G9:$G200,MATCH(BH2,'Sheet 1'!$A9:$A200,$BH16-$BH27)),""))

 

[pedro-egoli]

Thanks jason75 , Could not get that one to work.
Had a rethink and rejigged formula to
=IF(BH2="","",IF(BH18<>CHAR("252"),BH16-BH27,LOOKUP(9^99,'Sheet 1'!$G9:$G355)))

This gives me what I am after.
Thanks for your input