N nandhamnk New Member Sep 18, 2012 #1 Dear All, I need a formula help to re-arrange the data Below is the input: A2 B2 1 2 Red 3 4 Green 5 Yellow,Blue,White 6 7 8 Black 9 10 11 Purple 12 Output (Formula in D2) as below: C2 D2 Red 2 Green 4 Yellow 5 Blue 5 White 5 Black 8 Purple 11 Thanks for the support
Dear All, I need a formula help to re-arrange the data Below is the input: A2 B2 1 2 Red 3 4 Green 5 Yellow,Blue,White 6 7 8 Black 9 10 11 Purple 12 Output (Formula in D2) as below: C2 D2 Red 2 Green 4 Yellow 5 Blue 5 White 5 Black 8 Purple 11 Thanks for the support
K keymaster New Member Sep 18, 2012 #2 You can use INDEX + MATCH with * wild card to do this. In D2 write =INDEX($A$2:$A$13,MATCH("*"&C2&"*",$B$2:$B$13,0)) To know more about wildcard usage see - http://chandoo.org/wp/2010/11/01/using-wildcards-with-vlookup/
You can use INDEX + MATCH with * wild card to do this. In D2 write =INDEX($A$2:$A$13,MATCH("*"&C2&"*",$B$2:$B$13,0)) To know more about wildcard usage see - http://chandoo.org/wp/2010/11/01/using-wildcards-with-vlookup/
