=COUNTIF(A:A,84)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"shakey1181" wrote in message
...
I am struggling to get the following process to work:

Firstly, instead of vlookup returning a column index, I need it to return
a
'1'. Also if the same figure appears again in the same column, to return a
'1' and then add them together. So for example the vlookup is searching
for
'84' in column A, but it appears twice, so how would I get the destination
cell to show 2? Does that make sense?

I have tried several different methods, but I think this is beyond me.

Thanks in advance for any help