Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
Good luck to the 1,000 enterprise guinea pigs on the initial preview Anthropic has opened a waitlist for Claude for Excel, ...
You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.