> Uwe Brauer writes: > The ref "remote(table1,@2$7..@>$7)" targets a range, containing all fields of > colum 7. So, for each field, you get the same value: an array > containing all the field values: [22, 19, 19]. > See (info "(org) References"), in the section: > "Field coordinates in formulas" > "‘@#’ is substituted with the row number of the field where the > current result will go to". Aha, and has the benefit that the lookup call is not needed, but is more cryptic thanks for clarifying this. -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of Ukraine. I support the EU membership of Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/