Vlookup Part of Cell

[VegasL]

Hello,

I am trying to compare two sets of data on two different tabs.

Comparing tabs, GA vs Puburl

On tab puburl, the list contains data such as:

http://www.abcdef.com/dasfsdf/index.html
http://www.alllittirs.com

I want to compare this against the data in tab Ga, which contains data such as:

Source Numbers Euros
alllittirs.com 23973 454
defghi.com 7725 212


The end result should be in tab puburl:, to display the numbers and euros such as in example of spreadsheet attached.

If it doesn't find the matching result to display blank.

Basically, if the cell contains http://www. or anything preceding site.com, it should match.

I tried, =IF(ISNA(VLOOKUP("*"&GA!A2&"*",PUBURL!$A$2:$C$6,2,FALSE)),"",VLOOKUP("*"&GA!A2&"*",PUBURL!$A$2:$C$6,2,FALSE)) but that didnt give desired result, in pub url tab for cell b2 and copied down.