Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index / Match Question
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index / Match Question
Have you looked at your previous replies. You will not make friends here by
reposting the same question. -- Don Guillett Microsoft MVP Excel SalesAid Software "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 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Match question. | Excel Worksheet Functions | |||
Index match question | Excel Discussion (Misc queries) | |||
Index/Match Question | Excel Discussion (Misc queries) | |||
Index/match question. | Excel Worksheet Functions | |||
Match or Index Question | Excel Worksheet Functions |