find the second match using the match function

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I need to use the MATCH function to find the second location within an array
of a value. This function be able to query a closed external workbook.
 
if your range is from A2:a6 and the lookup value is in b7 then
=SMALL(IF(A2:A6=B7,ROW(A2:A6)-ROW(A1)),2)
array entered (ctrl+shift+enter)
 
Back
Top