Total matches found by vlookup

  • Thread starter Thread starter Rhodrey
  • Start date Start date
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.
 
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.
 
Back
Top