ExcelBanter - find the second match using the match function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - find the second match using the match function (https://www.excelbanter.com/excel-worksheet-functions/226866-find-second-match-using-match-function.html)

RaY

find the second match using the match function

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.

N Harkawat

find the second match using the match function

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)

"Ray" wrote:

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.

All times are GMT +1. The time now is 01:10 AM.