G
Guest
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.
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.