EXCEL: The INTERSECTION function

Last update on November 13, 2009 12:39 PM by jak58
Published by jak58

EXCEL: The INTERSECTION function







You have a table consisting of rows and columns.

Want to know the value of the cell at the intersection of a particular row / column in your table

Example:

Your table: 
- starts C3 to F3 ... for the column headings 
- Begins at C4 toC12... for titles of lines 
- Is filled with values, from D4 to F12
  • Click INSERTION / NAME / create / define the entire area of the table and select the areas under the proposed panel / ENTER.
  • Position your cursor to the cell of your choice (excluding the table .... where you wish to display the result)
  • write: = TitleColumn2 TitleLine3 (your actual title) .. and you get the value of the cell at the intersection.

Do not forget the space between the 2 titles; this is what defines the instruction NTERSECTION ".
Best answers for « EXCEL: The INTERSECTION function » in :
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Repainting a cell using excel VBA ShowRepainting a cell using excel VBA Issue Solution Note Issue I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim a1 As Integer Dim d1 As Integer Dim...
Sorting a table without using the sort function ShowSorting a table without using the sort function Getting started Pseudocode The coding Getting started First of all we initialize a variable $ max with the 1st value of table. Then we will make a loop until the table still contains...
Download Pop-up Excel Calendar ShowNow, it is possible to avoid entering manually dates in Excel worksheets. With Pop-up Excel Calendar you can have access to date directly in your Excel worksheet. Pop-up Excel Calendar is an add-in for Microsoft Excel allowing to display a small...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Spreadsheet - Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
E-Procurement - Management of the purchasing function Showe-Procurement The term "e-Procurement" (for Electronic Procurement, sometimes written eprocurement) refers to the use of new technologies to automate and optimize the purchasing function of the company. The term refers to a B2B exchange, i.e. a...
They need your help