Устраните два, передав поиск в Sheet3, если Sheet2 не работает.
=iferror(iferror(index(sheet2!d:d, match(a2, sheet2!b:b, 0)), index(sheet3!d:d, match(a2, sheet3!b:b, 0))), text(,))
Используйте getActiveWorkbenchWindow
в HandlerUtil
:
public class MyHandler extends AbstractHandler {
@Override
public Object execute(ExecutionEvent event) throws ExecutionException {
IWorkbenchPage workbenchPage = HandlerUtil.getActiveWorkbenchWindow(event).getActivePage();
workbenchPage.showView("MyView");
}
}