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

With
A1:D5 containing your data list

Try something like this:
=VLOOKUP("defect",A1:D5,MATCH("Cum",A1:D1,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


"Jithu" wrote:

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

1) =B2:G2 E1:E14
2) better if the ranges have names: =brange erange
The space between ranges is the intersection operator
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jithu" wrote in message
...
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

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

"Jithu" wrote in message
...
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

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
on changing)?

"Ron Coderre" wrote:

With
A1:D5 containing your data list

Try something like this:
=VLOOKUP("defect",A1:D5,MATCH("Cum",A1:D1,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


"Jithu" wrote:

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

Thanks you so much......

This is the one i need.

"Stephen Bye" wrote:

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

"Jithu" wrote in message
...
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