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