Using VLOOKUP to count.

S

shakey1181

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
 
B

Bob Phillips

=COUNTIF(A:A,84)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
N

Niek Otten

Look at COUNTIF. See HELP for details.

--
Kind regards,

Niek Otten

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