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

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

=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

Look at COUNTIF. See HELP for details.

--
Kind regards,

Niek Otten

"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
|
|