Total matches found by vlookup

R

Rhodrey

I have searched the threads but cannot find and answer to this
problem. I want VLOOKUP to return the amount of times if finds a match
on my spreadsheet. I need to know how many times a value occurs but
the formula only returns one match.
 
R

Rhodrey

Aladin Akyurek said:
Use COUNTIF instead...

=COUNTIF(INDEX(LookupTable,0,1),LookupValue)
Click to expand...

Hey thanks man. It really works. I really appreciate you help Aladin. Thanks again.
 
Top