[Tryster]

I'd guess your after something like this:

=left(trim(lookup(1,q3:q8,a3:a8)), 1)

I haven't tested it, but it should retrieve the first letter in column a for the the first value in column q that equals the value 1.

Cheers

Tryster