find second match if prior cell has same lookup value
What would be the best way to lookup values, if the next row contained same lookup value as the previous,so the first lookup (A5) pulls the first match and the second lookup (A6) with same value pulls the second match.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.