Hi,
Thanks for your quick reply. I can see what you're getting at but if I clarify it might help.
Here's my row of values (Row)
A B C D E F G H J
Here's my lookup (its a range)
A C E
G I J
I want to look at (row) and give a count of all the values in (row) that appear in (range) and put the answer in an adjacent cell in (row).
The answer in the above example would be 5.
B,D,F and H don't exist in (Range).
"I" was not searched for.
I have 1000 rows to calculate.
Thanks for your help,
Gary