Forum Discussion
Lookup iferror, index/match errors
In the Workers Register- employees are segmented according to worker type, department and role. Depending on the department selcted- employee names are selected from a list. Fields such as employee ...
SergeiBaklan. I just read up on the prefix _xlfn:
"Cause. The Excel workbook contains a function that is not supported in the version of Excel that you are currently running. For example, you may have opened a ..."
On which version of Excel are you? Please check here https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 for which ones IFNA is supported.
Anyway, instead if it you may use IFERROR(), just replace IFNA on it.
Replacing IFNA with IFERROR worked like magic SergeiBaklan! Thank you so much! I'm using Office 2010 btw.
Let me work on things now. The formula was the missing piece!
evitajere , okay, great to know you sorted this out