Multiple logical functions resulting in multiple outcomes

Hi all,
I'm trying to devise a formula whereby the outcome in a cell is dependent on the inputs from 4 other cells. Not only that, but the outcome has 4 potential text values, i.e. the text in A5 (4 possible outcomes) is dependent on the inputs from A1 to A4. For example, if A1 and A2 are both Y, then the outcome is text 1, if A1 and A3 are Y, but A2 and A4 are N, then the outcome is text 2, and so on. Is this even possible and where do I start?
I'm not sure if I've given enough information, but wouold just like some pointers in the right direction.
Many thanks,
Paddy

Originally Posted by Ron Coderre

For simplicity...try this example:
G1:H8 contains this list

YYYY	Text 1
YYYN	Text 2
YYNN	Text 3
YNNN	Text 4
NNNN	Text 5
NNNY	Text 6
NNYY	Text 7
NYYY	Text 8

Each cell in A1:A4 contains either "Y" or "N"

This regular formula returns the Col_H text that corresponds to the A1:A4 concatenated value
A5: =INDEX(H1:H8,MATCH(A1&A2&A3&A4,G1:G8,0))

Is that something you can work with?

By George, I think I can! Preliminary results seem favourable.
Many, many thanks.