Blog Updated with New Topic: Excel formula to lookup find 1st, 2nd (second) 3rd (third) to Nth occurrence in range and match multiple conditions through different columns

[vabs]

Excel formula to lookup find 1st, 2nd (second) 3rd (third) to Nth occurrence in range and match multiple conditions through different columns.

When you have to match multiple conditions simultaneously & also there are repeated matching values & you need to extract 1st matching value for the first case and second matching value for the second case and so on.

http://blog.excelvbalab.com/2016/04/excel-formula-to-find-nth-occurrenece.html

Kindly provide feedback & post your query here.

Cheers!!

[Ashish Kumar]

Dear Vaibhav Sir,

It's really difficult to make these kind of Rules and Formulas as per the requirement. It's really helpful. Superb...!!

Thanks for sharing.

Regards

Ashish