RE: Return a cell from more than just one row of data

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

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,SUMPRODUCT(($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.

Replies

In response to

Return a cell from more than just one row of data posted by lindsayhyle on Sun, 19 Aug 2007