To find if vlookup matches multiple values

**karthik11** · 06-03-2013, 01:25 AM

I need to know how to find out if there are multiple matches when i'm using vlookup.
ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(RC[-2],Sheet2!C6:C8,3,FALSE),"""")" --- this is the formula im using.
When I use this formula, it returns the first match. But I want to find out if there is multiple matches. Neither do I want the number of matches nor do I want to return the multiple matches. All i want is if there are multiple matches in 0(for no) and 1(for yes) format. Please help. Thanks in advance

**:) Sixthsense :)** · 06-03-2013, 01:54 AM

Why not simply countif like this?

Formula:

Please Login or Register  to view this content.

**sachinattri** · 06-06-2013, 06:14 AM

Sixthsense, how about if I want to bring the 'value' instead of the count??

**:) Sixthsense :)** · 06-06-2013, 06:19 AM

Please attach a sample workbook with expected output for better understanding

To find if vlookup matches multiple values

LinkBack

Thread Tools

Rate This Thread

Display

To find if vlookup matches multiple values

Re: To find if vlookup matches multiple values

Re: To find if vlookup matches multiple values

Re: To find if vlookup matches multiple values

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions