When I was using Lotus 123 I used a function called Xindex that would find
the intersection in a named ranged. Is there a function in Excel that will
do the same.

Example: @xindex(range,a1,"actual sales")

Where the range was a named range and cell a1 contained the salespersons
name I entered and "actual sales" was the column heading for the sales which
was in the first fow of the named range