INDEX OR Match Problem

C

carl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index / Match Question 1
INDEX OR MATCH 2
Index/Match ? 2
Match or Index Question 2
Concatenation Problem / VBA ? 5
Case Sensitive Query 7
Match, Index, Indirect ? 1
index and match help Please! 1

Top