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