Dear friend,
i want to create a formulae, a code is used to refer a list of items, and when i input that code in another sheet, all items related to that that code should come as input in the sheet. how can i do so?
| code | item | descripttion |
| ABU | A | AFADAF |
| ABU | B | AFADFG |
| ABU | C | AGRTT |
| ABU | D | SGTEH |
| ABU | E | ETHJH |
| ABU | F | HRTJH |
| ABU | G | HRYH |
| ABU | H | RHR |
| ABU | I | HRH |
| SAUD | J | RHYJYJY |
| SAUD | K | DHYJ |
| SAUD | L | HYRJ |
| SAUD | M | DHT |
| SAUD | N | DJYJ |
| SAUD | O | DJHDJ |
| SAUD | P | DHDHJ |
| SAUD | Q |
|
kinldy help
CAclubindia
