xlookup with arrays

Dear friends:

I have a table. I am trying to extract from this table 2 columns, specific rows only, via an xlookup. It returns a single column instead.

Why it does not work, and how to proceed ? Thanks!

xlookup.jpg

Xlookup will return a single row or column, but not both. Try

Formula:

Please Login or Register  to view this content.

It works! Thanks so much.

You're welcome & thanks for the feedback.