On 29/07/2007 01:43:58, JLatham wrote:
Regarding your question about putting the formula in a particular place:
it can actually go anywhere, but if you're going to keep a 1-to-1
relationship with the entries in column A, then yes, it would go into K2,
since they're starting at row 2.

I believe for the VLOOKUP portion of it you need a 'helper' column. Add a
new column C (leaving the long entries in B and associated values now in
D), then in C, put =LEFT(B2,Find(" ",B2)-1)
That will put same thing that's in your column A into column C. The
Vlookup array reference then changes to ,C$2:D$1501, and I think it'll
work for you. With the reduced length of the text in C, you may need to
watch out for early matches. Crude example...
In B you have 2 entries: Wins Easily and farther down there is Wins
Everytime
both of those will show up in C as Wins, and the VLOOKUP will only see the
first one in the long list.

In my sleep I was thinking similar, but you have done it for me! I will give
this a go.

Thanks for your help.