Intersection

[Guest]

Hi All,

Is it possible to find the intersection cell of two cells.

for eg
Goal Cum Curr
Pro
Defects ?
Estimate

i want to find the cells id(A2, B4 etc) of the intersection of cells with
data Defects and Cum(given as "?" in the eg)


Thanks in advance for the help.

Jithu

 

[Guest]

With
A15 containing your data list

Try something like this:
=VLOOKUP("defect",A15,MATCH("Cum",A11,0),0)

The VLOOKUP finds "defect" in the column list.
The MATCH finds "Cum" in the top row and returns the position (col number).

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP

 

[Bernard Liengme]

1) =B2:G2 E1:E14
2) better if the ranges have names: =brange erange
The space between ranges is the intersection operator
best wishes

 

[Stephen Bye]

You can use
=Cum Defects
and Excel will treat this as the intersection of the column labelled Cum and
the row labelled Defects.

 

[Guest]

Thanks Ron.

it is working. But one querry. is it possible to find the intersection if
the table in the eg can come anywhere inside the sheet.(Cell reference keeps

 

[Guest]

Thanks you so much......

This is the one i need.