# VLOOKUP migration from Ms.Excel to Calc

I have a Ms.Excel file that I used for months in Windows. Since now I am using Linux, I move from Excel to Calc. There is a VLOOKUP formula in that file that doesn't work on Calc.

*=+VLOOKUP(Excel_BuiltIn_Extract,$Sheet2.A4:C1000,2,TRUE())*

It only returns **#VALUE!**
I've read about VLOOKUP in Calc and what the #VALUE error code means, tried some solutions such as changing the cell format but it is still unable to work.
What should I do to make that formula work as how it worked in Windows?

Thanks

What is "Excel_BuiltIn_Extract"? This formula doesn't work for me on MS Excel 2016.

I'm not sure about that one, too. I received the file via email to work some administration task. I've browsed google to find the Excel_BuiltIn_Extract function and it's Calc's version but found nothing.

@Roihan: I suppose you know what you want to achieve based on the formula. Doesn't this knowledge enable you to find out by what expression or reference or whatever the first parameter must be filled

semanticallyto reach the goal?Though "Excel_BuiltIn_Extract" sounds somehow like a specific feature in Excel, it may also be a name chosen by someone else for a named Formula/Reference/VBAFunction that didn't properly translate to Calc internally. To recreate it you will need to know.

Sheet 1 is transaction form. Sheet 2 contains the Customers Identity. Sheet 1 uses that formula to take the value (Name, Address, and Number) from Sheet 2. Is there a way to check that named Formula/Reference/VBAFunction?

I found the named expressions. And in

range or formula expressionof Excel_BuiltIn_Extract , it contains$Sheet1.$AE$2Then AE2 links to another cell and so on until AF2. While AF2 is a combo box contains the name of the customers. Usually, I choose the customer's name using this combo box, then the cell Customer Name (The one contains the VLOOKUP formula) automatically filled by the name chosen on that combo box.Hopefully you did find a final solution based on the new insight?

If the named range is just one cell linked to a combo box, the chosen name is actually

verymisleading.