Multiple Match Returns

[ServiceChris]

I am trying to us the Match & Offset (or Index) functions to link dat
between two workbooks. Workbook 1 contains a postcode (in UK format)
and workbook 2 has a column that contains cells with many postcodes i
each, and I need to match the two together.

That I can do, apart from one problem.

Workbook 2 has more than 1 row that might have the same postcodes in i
- in fact I would expect it to. There is another column that I can us
to filter by when I view to get a unique set of rows. My question is
can I get match to return only from the current filtered views. Or ca
I somehow get match to check on values in 2 columns. Or do I need t
use an array to return them all, then search that again (and if that i
the case, I need help as I think that is a bit beyond me.)

Example data in workbook 2 might look like this :

Business Type Company Postcode
A This one AAA,BBB,CCC,DDD
B This one AAA,BBB,CCC
A Another one EEE,FFF,GGG
B And Again EEE,FFF,DDD

I know I am looking for business type A this time. The postcode i
EEE, so I would want to be able to find the company name 'Another one'

All help gratefully received

Chri

 

[Frank Kabel]

Hi Chris
are the postcodes for one compay in ONE single cell (separated by
comas) or are they in different cells?

 

[ServiceChris]

All the postcodes for the company are in one cell, seperated by commas.
For that reason, the match command works fine - except it only find
the first row that matches - If I tried to find a company type B wit
postcode EEE, I would still get the row number for 'Another One'.

Cheers, Chri

 

[ServiceChris]

Does anyone know if this is possible via standard functions, or would
be best trying to get a VB macro to do it