Reference LOOKUP not working

[blcakcatming]

upload excel but reference LOOKUP not working
version: keikai-app-5.10.0-Eval

[hawkchen]

according to LOOKUP doc, the 2nd argument is a lookup_vector, a range. But yours is 0/((B2:M2=C151)*(B4:M4=B151)) which looks like a number, not a range. I think that argument might be the root cause of the error.

[blcakcatming]

It is two ranges, B2:M2 and B4:M4, it can work well in Windows Excel

[hawkchen]

But your screenshot shows that the 2nd argument is 0/((B2:M2=C151)*(B4:M4=B151)) which is not range. Could show me the formula you mentioned or a sample xlsx file?

[blcakcatming]

demo.xlsx
Please look at this file J151:O151

[hawkchen]

I see. you want to match 2 criteria in LOOKUP like https://www.microsoft.com/en-us/microsoft-365/blog/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas/
But keikai doesn't support the syntax like B2:M2=C151. We need to find an alternative.

[blcakcatming]

I'm looking for another way out. Anyway, thank you for your reply