Hi all,
I have the following formula which works fine for alpha numeric criteria but does not return anything on numeric criteria only?
Could there be a reason I am missing here ?
=IF($B$10="","",IFERROR(LOOKUP(2,1/(Update!$FI$3:$FI$10002=$B$10)/(Update!$FJ$3:$FJ$10002=C19),(Update!$FF$3:$FF$10002)),""))
many thanks
I have the following formula which works fine for alpha numeric criteria but does not return anything on numeric criteria only?
Could there be a reason I am missing here ?
=IF($B$10="","",IFERROR(LOOKUP(2,1/(Update!$FI$3:$FI$10002=$B$10)/(Update!$FJ$3:$FJ$10002=C19),(Update!$FF$3:$FF$10002)),""))
many thanks
