If I understand you correctly, one way:

=COUNTIF(A:A,84)

In article ,
shakey1181 wrote:

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