danielrussell2
New Member
- Joined
- Mar 17, 2016
- Messages
- 17
Hey guys, I've searched but I am not sure I'm using the correct terms so I am sure I have not found something that is in fact on this site.
My problem is that I have a list in cell G2 ("1a, 2b, 4e" for example) which corresponds with columns R and S to give a value (column R has the 1a through x24 on its rows, and column S has the corresponding item - hinge, closer, etc). Example mark 1a is for hinges, 3c is for a lockset lever, etc.
The way the G column is listed, it has each mark required for the line item followed by a comma and a space "1a, 2b, 4e" for example. I can run the index match function and get it to return the corresponding value from column S if there's only one value in column G, but any time there's more than one mark listed in column G it messes the formula up. What I want is for a list to appear in column H with the corresponding item in list form (with the first item matching, then a comma, then a space, then the next item, etc etc)
what formula would I need to input into column H to run this? What I currently have is below (hopefully that'll help kickstart this)
=INDEX($S$2:$S$25,MATCH(G2,$R$2:$R$25,0))
My problem is that I have a list in cell G2 ("1a, 2b, 4e" for example) which corresponds with columns R and S to give a value (column R has the 1a through x24 on its rows, and column S has the corresponding item - hinge, closer, etc). Example mark 1a is for hinges, 3c is for a lockset lever, etc.
The way the G column is listed, it has each mark required for the line item followed by a comma and a space "1a, 2b, 4e" for example. I can run the index match function and get it to return the corresponding value from column S if there's only one value in column G, but any time there's more than one mark listed in column G it messes the formula up. What I want is for a list to appear in column H with the corresponding item in list form (with the first item matching, then a comma, then a space, then the next item, etc etc)
what formula would I need to input into column H to run this? What I currently have is below (hopefully that'll help kickstart this)
=INDEX($S$2:$S$25,MATCH(G2,$R$2:$R$25,0))
![p.png](/board/proxy.php?image=https%3A%2F%2Fpreviews.dropbox.com%2Fp%2Fthumb%2FAAQjQxqhl0Khmv6EUrvwE9d2AGFdI5iXbbiFLdK1KR67KDLzwdtHTLn811e9PACbgMYwdvNpNw3iS00ZwHRs7kx5hlMEJxNwl-jKbK439cgU8DNOGIVOxSAJUNbkPz28SAiGf1vmWQaAYKKHPRLMq7Nn8z5c70KfWNoJIU4U0tFC_fN8GlXzjUGmW35c5ivnmPnAXX1DVCEhKhz79BxWMXH4MmPmUeFuUGTQz1ZufiYTbR3yH9oQ1ZdeQz-ARjS3S-A%2Fp.png%3Fsize%3D1600x1200%26size_mode%3D3&hash=0f9d316f02bbd7d37b09cc82d0358ff0)