Hi,

I would like to lookup text values in a worksheet, but is it possible to
lookup a non-exact match with a text value?

E.g Lookup values attached to 'Apple' against value 'Apples'. For a lookup
or match to work, do they have to be exact, or is there an exception rule i
can use that will pick out similar?

Basically, I have 2 tables, one table on shape of fruit, containing a row of
details on 'Apple' and the other table, colur of fruit, containing a row of
details for 'Apples'.

i want to position the two rows onto the one row, because i know that
'Apple' and 'Apples' is the same thing, with the intention of collating all
details about apples onto one row. But the VLOOKUP will only lookup exact
values??

i have about 2000 rows, hence the need to automate this 'matching' process

If this can not be done, does anyone have any better ideas?

Many thanks in advance