LOOPKUP 2 values in array

  • Thread starter Thread starter digicat
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP 2 values in array 3
Total 1
How to programme this in excel? 5
Logical 5
Extracting the Month value from a fully qualified date column 5
array formula 2
calculate number of days 7
Quicker way of chaning Cell ref in Define Name 1

Back
Top