Thread: Intersection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 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