Vlookup and Indirect formula


Good Day !

I encounter a #REF! error using libre office Version: using the formula below.


I’m using multiple sheets

Thank you,



What is $D3&"_Sales"? It is expected to be a reference in A1 style (because an optional second arg to INDIRECT is missing). It could be a named range’s name, of course. But as you don’t attach a test sample, and even don’t tell what is there in D3, it’s impossible to check.