We all know that Offsetmatch can fetch an array of cells based on the lookup value. But what if i have the same value is more than once in the lookup column? Can i fetch as many array as i have the value in the column?
If available a non-vba solution is preferred.
Earnestly looking for the answer.