I have a sheet like this:
Date|101|102|103|104|
---------------------
1/1 | A | | | |
1/2 | | A | | |
1/3 | | | | |
1/4 | | | | A |
1/5 | | | A | |
Then on a second sheet, I would like to fill in the following question marks:
ID | DateA
-----------
101 | ?
102 | ?
103 | ?
I can identify the column on sheet 1 for each ID on sheet 2 using =match(A2,Sheet1!1:1,FALSE)
But I haven't been able to figure out how to then feed this into a second match a la =match("A",Sheet1!?results from above would go here to select the right column?,FALSE)
I have been looking at the indirect functions and address functions but it is not clear to me that they will do what I need.