Finding and displaying a cell reference

[Gary Thomson]

The following is a worksheet titled "UNAVAILABILITY". In
the following range there will always be ONLY ONE "a":

UNAVAILABILITY
A B C D E ....
1 Unit 1-Feb 2-Feb 3-Feb 4-Feb ....
2 Maths
3 English b b bc
4 Music bcd b abcde
5 P.E.
6 Geography
7 History
8 Drama
9 Science

In the case above, the "a" is in cell D4.

Now suppose that there is another worksheet, "USAGE",
which has a similar set up of Rooms and Dates, with "x"
denoting that a room was used on a given date.

i.e.

USAGE
A B C D E ....
1 Unit 1-Feb 2-Feb 3-Feb 4-Feb ....
2 Maths x x x x
3 English
4 Music x x
5 P.E. x
6 Geography x x
7 History
8 Drama
9 Science

I want to put a formula in cell A11 of
the "UNAVAILABILITY" sheet that will do the following:

=if(Usage!D4="x",1,0)

In this case the returned value would be 0, as there is
no "x" in cell D4 of the "USAGE" sheet.

The problem is, however, that the location of the "a" in
the "UNAVAILABILITY" sheet will change from month to
month.

So what I want is for excel to find the location of
the "a" in the UNAVAILABILITY sheet, then check if there
was an "x" in the corresponding cell of the USAGE sheet.



The above example assumed there was only one "a" within
the range. What if there was two? Can Excel return the
cell reference for both values, so that I can use both in
a formula?