I was using a sort macro to return the highest recurring defect to a specific cell, but after more research I think I can avoid the macro processing delay if I use the formulas of LARGE and VLOOKUP. For example, in columns B, I have the type of defect, and in column C is the number of occurences for that defect. I do not need to sort these, I just need to return the highest recurring defect to a specific cell.
Here's what I tried:
=VLOOKUP(LARGE($C$2:$C$8,1),$B$2:$C$8,1,FALSE)
but it returns #N/A.
Thank you for your help.

-Luke