| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Match problem | Excel Worksheet Functions | |||
| INDEX / MATCH problem | Excel Worksheet Functions | |||
| Possible index/match problem? | Excel Worksheet Functions | |||
| Array index, match problem | Excel Worksheet Functions | |||
| Index Match Problem | Excel Worksheet Functions | |||
Hybrid Mode
