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:  JMB
Date: Sun, 19 Aug 2007

where G1 contains the 2 letter code you are searching for, one way is:

=INDEX(A1:A4,SMALL(IF((C1:E4=G1),ROW(A1:A4)-MIN(ROW(A1:A4))+1),1))

array entered w/Cntrl+Shift+Enter (or you'll get #VALUE error).

"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

None

In response to

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