Vlookup with named range from another workbook

I am trying to use VLOOKUP using a Named Range from another Workbook, ideally from an existing Excel Workbook, but failing that, from another LO Workbook. Any ideas?

Which steps exactly are you doing? This can be very important for finding the solution.