ExcelBanter - INDEX OR Match Problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - INDEX OR Match Problem (https://www.excelbanter.com/excel-worksheet-functions/214565-index-match-problem.html)

Carl

INDEX OR Match Problem

I have a table like this:

ID Code Notes
BOX549 a2 Drop
BOX355 aA Drop
BOX355 AA Add

I am trying to find a formula for column "Notes" that will produce these
results (please note that the codes are upper and lower case alpha)

Code ID Notes
a2 BOX549 Drop
A3 BOX355
AA BOX355 Add
aA BOX355 Drop
Aa BOX355

Thank you in advance.

T. Valko

INDEX OR Match Problem

see your other post

--
Biff
Microsoft Excel MVP

"carl" wrote in message
...
I have a table like this:

ID Code Notes
BOX549 a2 Drop
BOX355 aA Drop
BOX355 AA Add

I am trying to find a formula for column "Notes" that will produce these
results (please note that the codes are upper and lower case alpha)

Code ID Notes
a2 BOX549 Drop
A3 BOX355
AA BOX355 Add
aA BOX355 Drop
Aa BOX355

Thank you in advance.

All times are GMT +1. The time now is 12:18 AM.