Lookup from an Array...

[GUIDO22]

I have a list of horse racing data for UK and Irish races.
What I wish to do is define a list of all IRISH track names -lets call this track array

I wish to search through a range of all race results in range say (A1:A100) and return an "I" character where any occurence of track array is found in this range.
In summary, I wish to clearly identify all Irish race results with a single 'I' character,

Track Array may have:
[Listowel
Navan
Cork] etc.

A1:A100, race results range may have :
12.30 Navan (the formula cell would return 'I')
13.00 Chepstow (the formula cell would returns nothing)
13.10 Cork = returns 'I' (the formula cell would return 'I')
........


What would be the cell formula I need in each cell to return 'I' for each Irish track found....

Thank you.

 

[NBVC]

Assuming the lookup track array is in another sheet, say Sheet2, in column A, then try a formula like:

=IF(ISNUMBER(MATCH(A2,'Sheet2'!A:A,0)),"I","")

copied down.

 

[GUIDO22]

Thanks for your suggestion, the trouble with this solution as I see it is that the first param to MATCH is the lookup value - which in this case is the full race title comprising not only the race trackname but also distance and race time etc.

eg.
Race string = 12:30 Cork 2m4f Nov Hurdle

So Match will never find a lookup match of the race string to the Race Name array.
It really needs to be the other way around if you follow... ie. the value we are looking for in the race string really needs to be 1...n entries from the array of Race Names.

 

[NBVC]

Try then:

=IF(ISNUMBER(LOOKUP(10^10,SEARCH('Sheet2'!$A$2:$A$10,A2))),"I","")

where Sheet2 A2:A10 contains the array of Race Names.

 

[GUIDO22]

Thank you for your suggestion - it got me thinking and I decided to strip out of the race string, the first four letters of each Race Track name id.
This was then the lookup value I search for in the array, also containing 4 letter track names for all unique race track names.....

Much appreciated.