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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Formula Using Vlookup & Match 3
Match and Vlookup issue 2
Vlookup and return sheet name also 2
VLOOKUP & Data Validation 0
trouble with (complicated) vlookup searching another workbook 2
First row where a cell is zero 2
return proper match from three columns 2

Top