Return a cell from more than just one row of data

Giganews Newsgroups
Subject: Return a cell from more than just one row of data
Posted by:  lindsayhyle
Date: Sun, 19 Aug 2007

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.

Replies