LOOPKUP 2 values in array

D

digicat

The table has dates in the columns and names in the rows
An x indicates who's on duty that day.

.............01-10-2004 ... 02-10-2004 ... 03-10-2004 .....
Sonja .........x
Dirk ...............................x
Katia .................................................. .x
Jan .............x

When I type a particular date, Excel should show the name with the x

03-10-2004
Katia

Who can help me solve the problem?
I have no knowledge of VBA code
 
F

Frank Kabel

Hi
try the following formula
=INDEX(A1:A20,MATCH("x",OFFSET(A1:A20,0,MATCH(X1,A1:X1,0)),0))
where X1 is the cell you enter your search date in
 
Top