Index / Match Question

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 "Notes" column in the table below that
will produce these results. Please note that the Code can have upper and
lower case alpha values.

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


Thank you in advance.
 
D

Don Guillett

Have you looked at your previous replies. You will not make friends here by
reposting the same question.
 

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 OR Match Problem 1
INDEX OR MATCH 2
Index/Match ? 2
Match or Index Question 2
Concatenation Problem / VBA ? 5
Cell Counter/Increment 2
How do I use case sensitive VLOOKUP? 8
LookUp/Match/Index/OffSet Question 4

Top