In answer though, yes you can use INDEX/MATCH or OFFSET/MATCH as alternatives
which will also get you round the problem of needing the lookup column to be on
the left.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
