[Dave Shaw]

I am using Excel 2007 and have a table (26,000 records) that for each I need
to match a long text string (up to 1000 characters) against a table of around
6000 records.

As excel only allows string of up to 255 characters I can't use vlookup.

Any ideas - I wondered if there was a simple VB macro that could acheive
this or whether there is a formula I could use on multiple criteria - i.e. I
can split the text on both tables into 4 so can I do a lookup or match
against all 4 - i.e. if all 4 columns match it returns a result?

Any help greatly appreciated.

[Dave Shaw]

Sorry managed to solve my own problem - give an index number to the smaller
lookup list and then use a sumproduct array formula to give the index number
and then vlookup against that.

"Dave Shaw" wrote:

I am using Excel 2007 and have a table (26,000 records) that for each I need
to match a long text string (up to 1000 characters) against a table of around
6000 records.

As excel only allows string of up to 255 characters I can't use vlookup.

Any ideas - I wondered if there was a simple VB macro that could acheive
this or whether there is a formula I could use on multiple criteria - i.e. I
can split the text on both tables into 4 so can I do a lookup or match
against all 4 - i.e. if all 4 columns match it returns a result?

Any help greatly appreciated.