I think I see how this could work, but since I am trying to get back text, I
am just getting an error(#VALUE!). Is there anything else I can do to get
back the text in the block I am searching for?

"Ron Coderre" wrote:

With your posted list in A1:E4

Try this:
F1: ( the letter couplet to find)

This formula returns the Task for that couplet
G1:
=IF(COUNTIF($C$1:$E$4,F1),INDEX($A$1:$A$4,SUMPRODU CT(($C$1:$E$4=F1)*ROW($C$1:$E$4))),"No Match")

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"lindsayhyle" wrote:

I have a spreadsheet that looks like this:

A B C D E
1 Task Name AA AL PX

2 Task Name BL CE DF

3 Task Name AE DV QW

4 Task Name AZ SR UV

I want to be able to make a list of the two letters in columns C, D, and E
and have it return the task in column A like this:
AA Name
AB Name
AL Name

and so on. Is this possible to do a search from multiple rows and columns
to return the task in column A? Thanks.