CODEWITHSUNDEEP
excelgoogle-sheets
Benedikt Wagner
Benedikt Wagner

Reputation: 31

Is there an easily readable equivalent for the Excel intersection operator (space) in Google Sheets?

In Excel, it is possible to use the space character as an intersection operator to obtain the intersection (in terms of constituent cells, not content) of two named ranges, for example:

=Horizontal_Range Vertical_Range

However, in Google Sheets attempting this returns a formula parse error, and online research seems to suggest that the intersection operator (at least in this form) is unavailable in Google Sheets.

Is there an easily readable equivalent in Google Sheets? The initial idea of using this with named ranges was to make the formulae more readable.

Thanks in advance for your help!

Upvotes: 3

Views: 120

Answers (2)

Tom Sharpe
Tom Sharpe

Reputation: 34275

You could also use offset in the event that the ranges weren't complete rows or columns but were still part of a single row and a single column:

=offset(A1,row(Revenue)-1,column(FY_2022)-1)

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36945

You can use INDEX() function like-

=INDEX(Inputs_2022,ROW(Revenue))

enter image description here

Upvotes: 1

Related Questions