Multiple Match Returns

  • Thread starter Thread starter ServiceChris
  • Start date Start date
S

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
 
Hi Chris
are the postcodes for one compay in ONE single cell (separated by
comas) or are they in different cells?
 
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
 
Does anyone know if this is possible via standard functions, or would
be best trying to get a VB macro to do it
 
Back
Top