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 ...
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