BUG: Index.get_indexer_for with mixed tuples
```
idx = pd.Index(["i", "i", "j"])
other = pd.Index([('i', 'i'), ('i', 'j'), ('j', 'i'), 'j'])

>>> idx.get_indexer_for(other)
ValueError: The truth value of an array with more than one element is ambiguous. Use a.any() or a.all()

mi = pd.MultiIndex.from_tuples(other[:-1])
mi.get_indexer(other)  # works!
```