Hi,
Could I please ask for some help on a formula that works fine except when there is nothing to return
=IFERROR(LOOKUP(2,1/(Update!$FL$3:$FL$5002=$B$1900)/(Update!$FO$3:$FO$5002=C1903),(Update!$FU$3:$FU$5002)),"")
Unfortunately when B1900 and C1903 is blank this formula returns a date format of "01/01/1900"
Is there a way to have the formula return "" if b1900 is ""
Many thanks for any help
Could I please ask for some help on a formula that works fine except when there is nothing to return
=IFERROR(LOOKUP(2,1/(Update!$FL$3:$FL$5002=$B$1900)/(Update!$FO$3:$FO$5002=C1903),(Update!$FU$3:$FU$5002)),"")
Unfortunately when B1900 and C1903 is blank this formula returns a date format of "01/01/1900"
Is there a way to have the formula return "" if b1900 is ""
Many thanks for any help