View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lindsayhyle lindsayhyle is offline
external usenet poster
 
Posts: 17
Default Return a cell from more than just one row of data

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.