Intersection
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
|