ExcelBanter - How to find next up matching cell?

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

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

- - How to find next up matching cell? (https://www.excelbanter.com/excel-worksheet-functions/257877-how-find-next-up-matching-cell.html)

DevourU

How to find next up matching cell?

The formula below works fine. I need replace "?" with If(A3<A2), search up
coulmn for first A3 match,C2, ""), Clear as mud? TIA!

=IF(A3A2,E2,(IF(A3=A2,C2,"?")))

-JS

All times are GMT +1. The time now is 05:22 PM.