Returns the value from a cell range which is the intersection of a row OR a column.
|value||The value to evaluate using implicit intersection.|
|* This function is only available in Office 365 to Office Insiders at the moment.|
* You can use the INDEX function to return the intersection of a row AND a column.
* This function is provided for backwards compatibility with implicit intersection formulas that can be used in earlier versions of Excel.
* You will no longer get implicit intersection of your formulas, instead, where it detects an implicit intersection, this function will be added.
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top