Thread: How to find next up matching cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DevourU DevourU is offline
external usenet poster
  
Posts: 11
Default 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
Reply With QuoteReply With Quote