Lookup returning blank on numeric criteria

[ExcelRoy]

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