Vlookup with Search function

[stevie2612]

Hi All

I have two tables i am trying to look up one for the other.

Table A is a list of licenses by Country with the Product names for each.

Table B is a list of the Product sales. The same Product code can be sold in different countries are in same cell separated by a semi colon.

Does anyone know how i can bring the sales into the license table?

Thanks

 

[arthurbr]

Perhaps a small Pivot Table?

 

[James006]

Hi,

You could test in cell C5
=IF(ISNUMBER(SEARCH("*"&B5&"*",$G$6:$G$10)),INDEX($H$6:$H$10,MATCH("*"&B5&"*",$G$6:$G$10,0)),0)

 

[stevie2612]

@James006 thanks i am getting a spill error when i enter in Cell C5.

I wasn't fully clear either I need to bring in the product as well into the formula as for Example Product C may have a License in Australia as well.