Help with formula - not sure what do to

[brendongl]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]www.reddit.com/r/news/blahblah[/TD]
[TD][/TD]
[TD]

[/TD]
[TD][/TD]
[TD]r/news[/TD]
[TD]News Politics[/TD]
[TD]1871511396470[/TD]
[/TR]
[TR]
[TD]www.old.reddit.com/r/news/blahblah[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
r/pics[/TD]
[TD]International[/TD]
[TD]90712378456[/TD]
[/TR]
[TR]
[TD]facebook/groups/1871511396470[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
r/dogs[/TD]
[TD]Dog Lovers


[/TD]
[TD]/doglovers123[/TD]
[/TR]
[TR]
[TD]facebook.com/groups/catsgalore[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]r/cats

[/TD]
[TD]Cat Lovers

[/TD]
[TD]/catsgalore

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hello.
Column A is where the data input occurs. We are placing URLs in there for facebook and reddit.

Column B is where i want which subreddit is the URL belongs to if it is a reddit URL. It has to be from a list from Column E. I cannot use a simple =left and =right formula because sometimes the url changes characters. I was thinking something like a vlookup but unfortunately, I dont know how to do that within a string of text.

Column C is where i want the name of the facebook group the URL belongs to. Column F is the list of names of the facebook groups, and column G is the idenfier which will exist in the URL. Some facebook groups are words and some are numbers. Same deal with column B but we have a seperate list to search under as it should search G in the column A and return F.

Any help would be muchly appreciated. This is happening on google sheets.





****** id="cke_pastebin" style="position: absolute; top: 70px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]r/finance[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[steve the fish]

If i read it correct maybe in B1:

=IFERROR(INDEX($F$1:$F$4,MATCH(TRUE,ISNUMBER(SEARCH($E$1:$E$4,A1)),0)),INDEX($F$1:$F$4,MATCH(TRUE,ISNUMBER(SEARCH($G$1:$G$4,A1)),0)))

Enter CTRL-SHIFT-ENTER