It is quite unusual to change the syntax of syntax – and I don´t remember situation like this in the Microsoft world.

So LOOKUPVALUE is an exemption. In a March version it got a new parameter – value, defining what has to be shown when no value is matched.

It is an interesting approach – if we had the same logic in VLOOKUP in Excel, no complicated combinations with IFERROR and IFNA would be necessary.


Leave a Reply

Your email address will not be published.


clear formPost comment